select distinct (a.sal) from emp a where &n = (select count (distinct(

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

Question Posted / reddy

Answer Posted / reddy

select distinct (a.sal) from emp a where &n = (select count
(distinct(b.sal) from emp bmwhere a.sal<=b.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is package in pl sql?

962

What are the advantages of stored procedure?

946

What are two statement types in sql?

1031

what is the difference between char_length and length? : Sql dba

990

Do we need to create index on primary key?

853

What is a join query?

906

what is view? : Sql dba

912

How to run sql functions in pl/sql?

989

What are predefined functions in sql?

977

Is sql developer case sensitive?

944

What is the main difference between sql and pl/sql?

1027

What is sequence in sql?

938

How many times can we commit in a loop?

956

What is user in sql?

967

What is procedure explain with example?

894