Select * From ( Select * From (select * from emp order by sal desc)

how to get second highest salary in SQL(as/4000

Question Posted / apurva

29 Answers
31186 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / apurva

Select *
From (
Select *
From (select * from emp order by sal desc)
Where rownum < 3 order by sal) ---> n+1 for example for
secound you should use 3
Where rownum < 2

Is This Answer Correct ?

4 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are myisam tables? : Sql dba

956

how to get a list of indexes of an existing table? : Sql dba

916

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

956

what is foreign key? : Sql dba

972

what is a database transaction? : Sql dba

1108

What is the difference between a primary key and a unique key?

1001

What is input buffer in sql*plus?

1127

What does := mean in pl sql?

991

How do I make my sql query run faster?

893

What is a subquery in sql?

977

How run sql*plus commands that are stored in a local file?

977

What is the difference between python and sql?

940

What is a temporal table?

882

what is union? : Sql dba

967

What is meant by cursor in sql?

943