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
What does postgresql do?
What is postmaster pid file in postgres?
How to display error message in postgresql?
What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?
What is psql?
Is postgresql like oracle?
What is bytea in postgres?
Is postgres distributed?
Is postgresql scalable?
How do you change columns in postgresql?
Is postgresql relational?
What is a foreign key example?
How do I open a pgadmin file in windows?
What is cluster control?
Does creating a foreign key create an index?