Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

This topic is locked

Trying to get 90th Percentail

Posted 10 Jun 2004 16:57:07
1
has voted
10 Jun 2004 16:57:07 Michael Bosquez posted:
I am trying to get the 90th percentile record from a recordset. By my definition, this would be the numeric field value where 90% of the records have a higher value and 10% have a lower value. Thoughts on how to do this??

Replies

Replied 12 Jun 2004 12:58:22
12 Jun 2004 12:58:22 Vince Baker replied:
THis should be possible in the sql, i will take a look at it and post back if I can crack it...

Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com
(Now completely CSS based and bye bye to all tables!)

VBScript | ASP | HTML | CSS | SQL | Oracle | Hosting

Reply to this topic