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

What is memory optimized?

1009

What is difference between ms sql and mysql?

910

What is a heap in sql?

992

Describe sql comments?

960

How to place comments in pl/sql?

1096

What is delete command in sql?

1051

Does truncate release storage space?

1013

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

931

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

1010

How does a self join work?

991

Is sql a oracle?

914

what are all the different normalizations? : Sql dba

960

How many sql are there?

924

What are the methods of filing?

876

What steps server process has to take to execute an update statement?

920