Answer Posted / liju
nth lowest
nth lowest
*******************************************************
SELECT DISTINCT (A.sal) FROM EMP A WHERE (N-1) =
(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
WHERE b.sal<a.sal);
nth highest
*******************************************************
SELECT DISTINCT (A.sal) FROM EMP A WHERE (N-1) =
(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
WHERE b.sal>a.sal);
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What are the data types in postgresql?
What does postgresql stand for?
Is postgres a database?
What are the indices of postgresql?
Is postgresql a sql server?
Is postgresql like oracle?
How do you delete data on pgadmin?
What is the blob data type?
Is postgresql free to use?
What does postgresql do?
What is edb postgres?
How secure is postgresql?
Is postgresql better than oracle?
Is postgresql a database?
Is primary key indexed by default?
