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 are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1069

How much does sqlite cost?

1040

Can a varchar be a primary key?

1009

What is autocommit sql?

996

What is the difference between null value, zero, and blank space?

1206

What is the maximum size of sqlite database?

1112

What is identity column in sql server?

1049

Can we use join in subquery?

1096

What is clustered index in sql?

1052

How do I view a table in sql?

1009

What is meaning of <> in sql?

1070

What is view explain with example?

932

What can sql server reporting services do?

1112

What's the difference between a primary key and a clustered index?

986

what is a cursor? : Sql dba

1024