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
How do I alter a column in postgresql?
How do I add one column in postgresql?
What are the advantages of postgresql?
What is foreign key in access?
How does clustering in improving the performance?
How do I connect to pgadmin server?
What is postgres vacuum?
What is the difference between sql and postgresql?
What does truncate table do?
What is the difference between oracle and postgresql?
Is postgresql the same as mysql?
Why is pgadmin used?
What is a postgres tuple?
What do you mean by catalog?
Is mysql faster than postgresql?
