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

92 Answers
151547 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an oracle cursor variable?

1085

Explain the use of tables option in exp command.

1123

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1996

What is a trigger and what are its types?

1239

please explain.. DB architecture ...

2029

Will you be able to store pictures in the database?explain.

1000

How to concatenate two text values in oracle?

1118

What is the quickest way to fetch the data from a table?

1061

Will you be able to store pictures in the database?

1129

How do I connect to oracle database?

1129

Explain the use of show option in imp command.

1103

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2317

What is pragma autonomous transaction in oracle?

1078

How to install oracle odbc drivers?

1099

Differentiate between translate and replace?

1125