SELECT MIN(sal) FROM emp WHERE sal IN (SELECT distinct TOP 3 sal FROM e

find out the third highest salary?

Question Posted / biswapratap singh

Answer Posted / biswapratap singh

SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal DESC)

Is This Answer Correct ?

214 Yes

73 No

Please Help Members By Posting Answers For Below Questions

What is the maximum number of triggers that can be applied to a single table?

956

How to create additional tablespaces for an new database?

972

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2073

What is a Garbage Collection? and what is full recursive Garbage collection?

2848

What is oracle server autotrace in oracle?

1091

Explain the use of owner option in exp command.

994

How many categories of data types?

940

material view and view disadvantages?

1021

How to handle a single quote in oracle sql?

975

How to create an oracle testing table?

1011

Is oracle the best database?

918

What is a static data dictionary in oracle?

1029

How to fetch the row which has the max value for a column?

950

How to select some columns from a table in oracle?

1007

How can you use check constraints for self referential integrity?

920