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

How do I view postgresql data?

426


What is rds instance?

449


What is the blob data type?

404


What is medical indexing?

437


Provide a brief explanation of the functions in postgresql.

442






What does GEQO stands for in PostgreSQL?

1039


How is postgresql different from oracle?

413


How do I start pgadmin 4 on windows?

442


Is postgresql good?

458


How do I rename a column in postgresql?

452


Does drop table also drop indexes?

434


What is the port 5432?

472


How do I add another column in postgresql?

427


Does creating a foreign key create an index?

446


What is foreign key in access?

447