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

How to assign a tablespace to a users in oracle?

1046

How to delete a column in an existing table in oracle?

1069

WHAT IS ecc 6.0

2147

How to rename a tablespace in oracle?

1085

When do you get a .pll extension in oracle?

1144

What is the difference between 10g OEM and 11g OEM?

965

Explain the characteristics of oracle dba?

1118

How to create a new tablespace in oracle?

983

How to count groups returned with the group by clause in oracle?

1075

What are group functions in oracle?

1038

What happens if you lost a data file?

1034

What is index-organized table in Oracle?

1068

What is raw datatype?

1134

Does oracle partitioning improve performance?

992

How to return top 5 rows in oracle?

1059