how to find nth lowest salary

Answer Posted / hari.sidd

SELECT DISTINCT (A.sal) FROM EMP A WHERE &N =

(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B

WHERE a.sal>=b.sal);

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is pgadmin used?

575


Does postgres use sql?

600


Can postgres scale horizontally?

595


What is connection limit in postgresql?

566


Is postgresql a relational database?

533






Is postgresql similar to sql server?

598


What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

1042


How to get current date in postgresql?

630


How to create local server in postgresql?

568


What is edb postgres?

582


What is sequences in postgresql?

585


What is foreign key in access?

574


Where are postgres databases stored?

598


Does postgres create indexes for foreign keys?

590


What is a user view?

545