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

What are tables in sql?

999

What problem one might face while writing log information to a data-base table in pl/sql?

1067

Can we create foreign key without primary key?

933

What is database sql?

988

What are the types of sql commands?

1020

how many ways we can we find the current date using mysql? : Sql dba

1038

What is recursive join in sql?

948

What is autocommit sql?

925

What is meant by <> in sql?

895

Explain dml and ddl?

923

what are enums used for in mysql? : Sql dba

1114

Can unique keys be null?

853

Is primary key clustered or nonclustered?

954

what is cross join? : Sql dba

941

What is type and rowtype in pl sql?

967