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 is the Maximum size for a table in PostgreSQL?
How do I start postgresql on windows?
What is the default database in postgresql?
What happens to index when table is dropped?
What port does pgadmin use?
Which are different types of database administration tools used in postgresql?
What are the advantages of postgresql?
How does postgres store data?
What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?
What is the latest version of postgresql?
What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes
Does aws support postgresql?
What is the difference between oracle and postgresql?
What does postgresql stand for?
What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?
