Rank and %Tile

Question

Post reply

Rank and %Tile

pat-261672

Hall of Fame

Points: 3325
More actions
December 13, 2008 at 1:58 pm

#127433

Hi all,
How can i get the rank, total rank and percentile in SQL I have no clue!!
Please guide!!
Thanks
Pat

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

For a reasonable short course, but complete with sample code

Part 1

http://www.databasejournal.com/features/mssql/article.php/3773091/SqlCredit--Part-19-Exploring-SQL-2005s-Ranking-Functions--RANK-and-DENSERANK.htm

Part 2

http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005s-Ranking-Functions--NTILE-and-ROWNUMBER.htm

These articles will definitely get you started.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

pat-261672 Hall of Fame Points: 3325 More actions · Answer 2

Thanks for thta.. also looking for the Quartile? Don;t know what that means neither the requestor in company?

Thanks

Pat

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

If my statistics courses did not leave me .... this is about it

first quartile (designated Q1) = lower quartile = cuts off lowest 25% of data = 25th percentile
second quartile (designated Q2) = median = cuts data set in half = 50th percentile
third quartile (designated Q3) = upper quartile = cuts off highest 25% of data, or lowest 75% = 75th percentile
The difference between the upper and lower quartiles is called the interquartile range.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

pat-261672 Hall of Fame Points: 3325 More actions · Answer 4

pat-261672

Hall of Fame

Points: 3325

December 14, 2008 at 10:46 am

#912221

how can i put it in to SQL now!!

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

Read this article, follow its sample T-SQL code, be sure to scroll down to the explanation for "NTile" and I believe a value of 4 will provide you what you want.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1320303,00.html

Then come back with your code, table structure, sample data as per the article in my signature block if you have additional questions.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]