Select TOP 1 salary from (select Distinct TOP 2 salary from employee orde

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / amitkumar

Answer Posted / amitkumar

Select TOP 1 salary from (select Distinct TOP 2 salary from
employee orderby salary desc)

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to use in conditions in oracle?

1116

Oracle

2427

Is oracle an operator?

986

How to insert a new row into a table in oracle?

1217

Difference between hot backup vs. Cold backup?

1040

What is blob datatype?

1203

What do you understand by a database object? Can you list a few of them?

1066

Explain constraining triggers.

1167

What are the uses of a database trigger?

1037

How to view existing locks on the database?

1103

How to use like conditions in oracle?

1115

What is Trigger in Oracle?

1244

How to resolve the ORA-39133 error in Oracle?

1184

How to call a stored function in oracle?

1068

What are the differences between primary key and unique key?

1064