Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / sushma
SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum <= 2
MINUS
SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum < 2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are ddl statements in mysql? : Sql dba
What is sql partition?
What are sql*plus environment variables?
What is the difference between python and sql?
Is null operator in sql?
What is implicit cursor in pl sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What operating systems are supported by oracle sql developer?
What is pls integer?
What is compound trigger?
What does where 1 1 mean in sql?
How many types of functions are there in sql?
What are the two types of cursors in pl sql?
Is not equal in sql?
What port does sql server use?