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 does partition by mean in sql?

957

what are the properties and different types of sub-queries? : Sql dba

1032

What is the use of <> sql?

976

What is flag in sql?

1029

What are the types of variables use in pl sql?

1039

What does subquery mean in sql?

1046

What is a database? Explain

1105

How can one get sql*loader to commit only at the end of the load file? : aql loader

1057

Is clustered index a primary key?

947

What is the process of copying data from table a to table b?

1086

How can I speed up sql query?

958

Mention what pl/sql package consists of?

995

Is left join faster than join?

1045

How do I truncate a word?

1085

How does cross join work?

947