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 is the use of geoserver?
What are string constants in postgresql?
What is a table catalog?
Does vacuum full reindex?
How to display error message in postgresql?
What is greenplum db?
What is the password of postgres user?
Is edb postgres free?
How many byte Unique integers does OIDs in PostgreSQL have?
Is postgres a mpp?
How to start, stop and restart postgresql database?
What is pg bouncer?
Is postgresql similar to sql server?
What is the driver name for postgresql?
Which key can be used to execute a query in the query editor?