Find out the 3rd highest salary?

Answer Posted / manoj

SELECT min(salary)
FROM (
SELECT e.salary , ROWNUM
FROM emp e
ORDER BY salary DESC
AND ROWCOUNT <=3
)
ROWNUM =3;

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does mysql_real_escape_string prevent sql injection?

545


Is oracel sql developer written in java?

658


How much does a sql dba make? : SQL DBA

522


Which query operators in sql is used for pattern matching?

554


What is sql query limit?

515






What is trigger price?

552


Does sql*plus also have a pl/sql engine?

567


What is the maximum database size for sql express?

544


What is the difference between jpql and sql?

565


What is compute?

565


What is procedure and function?

524


State some properties of relational databases?

591


Can we use insert statement in function?

528


What is the difference between Union and Union all. Which is faster.

852


Define union, minus, union all, intersect ?

560