The answer query is...... Select max(sal) from emp a where (&N-1) in

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

Question Posted / gaurav mishra

Answer Posted / gaurav mishra

The answer query is......

Select max(sal) from emp a where (&N-1) in(select count
(distinct(b.sal)) from emp b where a.sal<b.sal);

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between join and natural join?

924

In a distributed database system, can we execute two queries simultaneously?

1077

how to increment dates by 1 in mysql? : Sql dba

974

Can 2 queries be executed simultaneously in a distributed database system?

1138

Can we use having without group by in sql?

979

how to enter characters as hex numbers? : Sql dba

1033

What are all the ddl commands?

1177

what is auto increment? : Sql dba

1000

What is use of package in pl sql?

1009

What is java sql driver?

1107

What is attribute indicator in pl sql?

1009

What is the difference between rollback and rollback to statements?

1058

Mention what is the function that is used to transfer a pl/sql table log to a database table?

978

Which software is used for pl sql programming?

980

How do you identify a primary key?

1059