SELECT MIN(salary) FROM Department WHERE salary IN (SELECT TOP 3 salary FR

find out the third highest salary?

Question Posted / chanchal

Answer Posted / chanchal

SELECT MIN(salary) FROM Department WHERE salary IN
(SELECT TOP 3 salary FROM Department ORDER BY salary DESC)

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between "as" and "is" in an oracle stored procedure?

991

How to convert dates to characters in oracle?

1041

Explain table?

1115

What is an external table?

1020

How to define an anonymous procedure without variables?

1107

Explain the use of Merge statement in oracle 11g

1027

How does one get the view definition of fixed views/tables?

1021

How to create an initialization parameter file?

1049

What is backup in Oracle?

1004

Can we use bind variables in oracle stored procedure?

950

What is the best way to do multi-row insert in oracle?

1067

How to define default values for formal parameters?

1044

Explain the use of full option in exp command.

1116

How to pass parameters to procedures?

1034

How to connect the oracle server as sysdba?

1077