Top Value in a Table

[kavi2012]

Hi all

I need to get a 2'nd top Salary from the table Employee. I don't know how to write a query for this in postgresql. Could you please help me out to write.

I tried in MSSQL. It is working fine.
select top 3 salary from employee

But it is not working in Postgre. What is the equivalent for Top in postgre.

Thanks
Kavitha

[amitpatel66]

Hi all

I need to get a 2'nd top Salary from the table Employee. I don't know how to write a query for this in postgresql. Could you please help me out to write.

I tried in MSSQL. It is working fine.
select top 3 salary from employee

But it is not working in Postgre. What is the equivalent for Top in postgre.

Thanks
Kavitha

Try below Query to get second highest salary from the table:

SELECT MIN(e.salary) FROM emp e WHERE 2 > (SELECT COUNT(*) FROM emp WHERE salary > e.salary)
 

[rski]

or like that

select salary from (select distinct salary from emp group by salary order by salary) t order by t.salary limit 1 offset 1;

[kavi2012]

thank you for your fast reply. It is working fine..