Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
find Nth Percentile
47 views
Skip to first unread message
brandon...@gmail.com
Dec 28, 2012, 8:01:08 AM12/28/12
to
I use Sybase 12.5 ASE, and need some TSQL for the following:
My table looks like this:
Date Value
There are many records for each date.
I want to find the 25th 50th and 75th percentile for each date.
The only way I can think of is to use a cursor in a loop (yuck).
Does anyone have any SQL code to compute several percentile rankings for each date?
Thank you in advance
Brandon
My table looks like this:
Date Value
There are many records for each date.
I want to find the 25th 50th and 75th percentile for each date.
The only way I can think of is to use a cursor in a loop (yuck).
Does anyone have any SQL code to compute several percentile rankings for each date?
Thank you in advance
Brandon
0 new messages