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
33018 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 is 'mysqlimport'? : Sql dba

1115

How to convert comma separated string to array in pl/sql?

1242

Explain ddl statements in pl/sql?

1051

What is difference between pl and sql?

1111

How to select unique records from a table?

1111

Does truncate free space?

1065

define sql delete statement ? : Sql dba

1068

How can we implement rollback or commit statement in a trigger?

1085

what is a unique key ? : Sql dba

1151

What is pls_integer in pl sql?

1158

Is sql low level language?

1066

What is a sql profiler?

1066

What are the most important ddl statements in sql?

1189

How many parts of a pl sql block are optional?

1219

What is normalization in sql?

1067