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
What is shared_buffers postgresql?
How do I rename a column in postgresql?
What is write ahead logging in postgresql?
How do you remove a foreign key constraint?
Is postgresql free for commercial use?
What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?
Is postgresql better than oracle?
Is mysql faster than postgresql?
Can postgresql run on windows?
What is pgadmin used for?
What is gis data?
How to drop a constraint in postgres?
Is postgresql better than mongodb?
What is pg pool?
What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?