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
32266 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 the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1042

What are the types pl/sql code blocks?

1138

List out the acid properties and explain?

966

How does index help in query performance?

1032

What is coalesce in sql?

1067

What do you mean by field in sql?

1087

What are the different ddl commands in sql?

1176

What are the features of pl sql?

1071

How to rename a column in the output of sql query?

1072

What are the advantages of stored procedure?

1005

Can we use the cursor's to create the collection in PL/SQL?

1031

What program will open a mdb file?

970

What mean sql?

1019

How does a self join work?

1133

What are the types of join and explain each?

1054