select * from (select sal,rownum rn from(select sal from emp order by sal d

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

Question Posted / mohamed shahid

Answer Posted / mohamed shahid

select * from (select sal,rownum rn from(select sal from emp order by sal desc)) where rn=2;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between hql and native sql?

1093

what are all the different types of indexes? : Sql dba

998

What is sql constant?

945

What are the different schemas objects that can be created using pl/sql?

969

what is bcp? When is it used?

1049

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158

What is a primary key? Explain

922

Why sql query is slow?

931

What is mutating table error?

1118

What is update query?

922

What do you think about pl/sql?

950

How many types of keys are there in sql?

988

How to change the order of columns in Oracle SQL Plus ?

998

How to move files from one directory to another in pl sql?

1130

What is pl sql script?

979