how about :
SELECT (count( b.unique_id ) + 1) ranking
FROM table_name a, table_name b
WHERE a.unique_id = '4' AND b.score a.score
Mike wrote:
Let's say I have a database and I want to find the position of a row when it is
ordered by a specific column
before a sort:
UNIQUE ID | SCORE
Let's say I have a database and I want to find the position of a row when it is
ordered by a specific column
before a sort:
UNIQUE ID | SCORE
1 | 100
2 | 50
3 | 30
4 | 80
5 | 50
after sort:
UNIQUE ID | SCORE
1 | 100
4 |