select a.sal from ( select sal ,rownum no from (

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / khandu shinde

Answer Posted / khandu shinde

select a.sal
from (
select sal ,rownum no
from (
select distinct sal
from emp
order by sal desc
)
) a
where a.no=2

Is This Answer Correct ?

16 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How do I run a sql script?

1142

What are sql functions? Describe the different types of sql functions?

1139

Where do we use pl sql?

991

What is the execution plan in sql?

1019

what is the difference between where clause and having clause? : Sql dba

995

What is the mutating table and constraining table?

1023

Why do we create stored procedures & functions in pl/sql and how are they different?

940

List different type of expressions with the example.

931

What does the file extension accdb stand for?

968

What is the difference between pl and sql?

1090

Is pl sql better than sql?

1021

What is the use of %rowtype?

1032

How to display Row Number with Records in Oracle SQL Plus?

1043

Can one improve the performance of sql*loader? : aql loader

1045

Is primary key a clustered index?

963