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
How do I add a primary key in pgadmin?
How do you delete a row in a table?
What is bytea in postgres?
Can you store images in postgres?
Are foreign key constraints necessary?
What happens to index when table is dropped?
What is pgadmin 4 written in?
What does mvcc mean?
How do I enable postgis on pgadmin?
What is multi-version control?
How do you delete a column?
What is the default postgres database?
Is postgresql better than sql server?
What is postgresql?
Does postgres use sql?