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

Where is postgres configuration file?

514


How do I start a pgadmin server?

515


Can we add foreign key without primary key?

536


How to execute a function in postgresql?

526


List some of the features of postgresql ?

519






What is cluster in postgresql?

486


What are foreign key constraints?

607


What is a foreign key constraint why are such constraints important?

502


What is postmaster pid file in postgres?

591


What is the driver name for postgresql?

493


How to create local server in postgresql?

476


What ports does postgresql use?

542


How do you edit a table in pgadmin?

475


What is a ctid?

557


Does postgresql have a gui?

455