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
How do you delete a row in a table?
What is postgres xc?
How does pgadmin connect to remote database?
Is mysql better than postgresql?
How to write pl sql in postgresql?
Where is postgres configuration file?
How do I alter a table in postgresql?
What is psql command?
How do I rename a column in postgresql?
What happens to index when table is dropped?
How do I alter a column in postgresql?
Which are different types of database administration tools used in postgresql?
Does drop table remove indexes?
What is postgres vacuum?
Where is postgresql conf in mac?
