Question

In pgAdmin, i have a employee table( name, salary) like this   

Name	salary
TOM	3000
Jack	2000
Mike	6000
Susan	3000
Chris	5000
Nancy	5000

If i do select name, salary, densen_rank() over (order by salary desc ) as AA from table ,it'll return me a table like this

Name	Salary	AA
Mike	6000	1
Chris	5000	2
Nancy	5000	2
Suan	3000	3
Tom	3000	3
Jack	2000	4

Is there anyway i can write a query and return me just a specific employee and the rank of his salary? Like (Tom,3), or (chris,2) . I don't want a whole table.

Thnaks a lot!

Answer 1

You can do use the where clause like this:

select name, salary, dense_rank() over (order by salary desc ) as AA from table where Name="Tom"

Or if you want to search for someone by rank

select name, salary, dense_rank() over (order by salary desc ) as AA from table where AA=2