select sal from emp e where 2= (select count(distntsal) from emp y where e

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

Question Posted / naresh

Answer Posted / naresh

select sal from emp e where 2= (select count(distntsal) from
emp y where e.sal<=y.sal);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Write a sql select query that only returns each name only once from a table?

1019

How do I save a sql query?

1018

How to write pl sql program in mysql command prompt?

1102

Does varchar need length?

999

what is the use of friend function? : Sql dba

1023

what are the 'mysql' command line arguments? : Sql dba

1144

Which are sql * plus commands?

1132

What is a common use of group by in sql?

1051

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

How do I view stored procedures?

979

What company owns postgresql?

1032

What is a composite primary key?

1095

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1000

Why we use pl sql?

963

What is the purpose of cursors in pl/sql?

1138