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

How many types of sql are there?

1047

what is denormalization. : Sql dba

1162

what is an index? : Sql dba

1045

How can triggers be used for the table auditing?

1119

How do I view tables in sql developer?

1009

What are the benefits of stored procedures?

1126

How do I kill a query in postgresql?

1188

Why we use triggers in mysql?

1041

How do I create a sql database?

1055

What is the use of sql trace?

1006

Does sap use sql?

1041

What is a primary key? Explain

1028

What is Collation Sensitivity ? What are the various type ?

1001

Explain correlated query work?

1109

What is the difference between the implicit and explicit cursors?

1111