how to find nth lowest salary

Answer Posted / ezhumalai

with cte
as
(
select Salary,row_number() over ( order by Salary asc)rnt from EMP
)select * from cte where rnt=2

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you have a composite foreign key?

410


How do you run a query in pgadmin 3?

398


What is the driver name for postgresql?

419


How many types of replication are there in postgresql?

372


What is postgresql?

474






Can postgresql run on windows?

444


What does postgresql mean?

426


How to access postgresql database from another machine?

398


How do I get a list of databases in a postgresql database?

488


What is special about postgresql?

420


Is postgresql scalable?

392


Where is postgresql conf in mac?

475


How do I stop a postgresql console?

421


How do I change the default postgres password?

439


How to setup postgresql sysv startup script?

462