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
Can you have a composite foreign key?
How do you run a query in pgadmin 3?
What is the driver name for postgresql?
How many types of replication are there in postgresql?
What is postgresql?
Can postgresql run on windows?
What does postgresql mean?
How to access postgresql database from another machine?
How do I get a list of databases in a postgresql database?
What is special about postgresql?
Is postgresql scalable?
Where is postgresql conf in mac?
How do I stop a postgresql console?
How do I change the default postgres password?
How to setup postgresql sysv startup script?