Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why is pgadmin used?
What is edb postgres?
Is postgresql a language?
What is write ahead logging in postgresql?
What does postgresql mean?
How do I connect to pgadmin server?
How to get the ddl of a table in postgresql?
Is postgresql is nosql?
Is postgresql like oracle?
How to open postgresql gui in ubuntu?
How do I create a foreign key in postgresql?
What is postgresql?
How do I modify a table in postgresql?
What is multiversion two phase locking?
Which method is used to load the driver?
