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 increment dates by 1 in oracle?

1136

How to join two tables in a single query using oracle?

1052

How to define a sub function?

1199

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2599

Is oracle a programming language?

1037

What is the use of aggregate functions in oracle?

1071

State the various uses of dbcc command?

1104

Explain table?

1175

What is the dynamic sql in oracle?

1131

What is hot backup and logical backup?

1111

What is backup in Oracle?

1076

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2263

What is a database table in oracle?

1069

What is ordinary table in oracle?

1238

When do you get a .pll extension in oracle? Explain its importance

1097