SELECT min( sal ) FROM emp WHERE sal IN ( SELECT DISTINCT sal FROM e

how to check the 3rd max salary from an employee table?

Question Posted / danny

Answer Posted / danny

SELECT min( sal )
FROM emp
WHERE sal
IN (

SELECT DISTINCT sal
FROM emp
ORDER BY sal DESC
LIMIT 0 , 3
)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does a covering index work?

907

Can a procedure in a package be overloaded?

984

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1021

What is a sql select statement?

996

When are we going to use truncate and delete?

927

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1041

What is PL/SQL Records?

1116

define sql insert statement ? : Sql dba

976

What is a null value?

1089

What is java sql driver?

1040

What are system versioned tables?

969

What are different methods to trace the pl/sql code?

1050

What is sql lookup?

865

Why join is faster than subquery?

1048

What is recursive stored procedure?

1048