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 database sql?

1097

how to drop an existing view in mysql? : Sql dba

1102

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1243

How can triggers be used for the table auditing?

1117

What is substitution variable in pl sql?

1106

What is a table in a database?

1094

What is hibernate and its relation to sql?

1167

Explain the select statement in sql?

1180

What is a scalar value in sql?

1122

What are the different types of dbmss?

1054

Difference between table function and pipelined function?

1079

What is primary key in db?

1067

Can a key be both primary and foreign?

1053

How many databases can sql express handle?

1028

What is a join?

1104