Ranking Results - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Ranking Results

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-29 : 09:08:06

James writes "I want to know a script that will give a rank number to my results, where the same score gets the same rank.

eg.

This is my Table:


NAME           | DATATYPE

strName        | string
iScore         | integer

This is the result I want to be returned:


RANK | NAME         | SCORE

1    | James Walsh  | 10
1    | Someone      | 10
1    | Someone      | 10
4    | Mr Me        | 9
4    | Mr You       | 9
6    | Ja Ja        | 7
7    | You          | 4

Note that the rank is the same for the scores that are the same.

Is there a script that can do this???
"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources