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
Does mysql_real_escape_string prevent sql injection?
Is oracel sql developer written in java?
How much does a sql dba make? : SQL DBA
Which query operators in sql is used for pattern matching?
What is sql query limit?
What is trigger price?
Does sql*plus also have a pl/sql engine?
What is the maximum database size for sql express?
What is the difference between jpql and sql?
What is compute?
What is procedure and function?
State some properties of relational databases?
Can we use insert statement in function?
What is the difference between Union and Union all. Which is faster.
Define union, minus, union all, intersect ?