select * from emp where 2(select count(distinct sal) from emp e where sal&

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

Question Posted / prasanna

Answer Posted / prasanna

select * from emp where 2(select count(distinct sal) from
emp e where sal>=e.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is gpt format?

993

What is left join example?

1009

what are different types of collation sensitivity? : Sql dba

1121

What is implicit cursor in pl sql?

1148

What is difference sql and mysql?

1038

what are the drivers in mysql? : Sql dba

1061

What is view? Can we update view

1523

what are the advantages of using stored procedures? : Sql dba

1157

What is the use of stored procedures?

1110

How many scalar data types are supported in pl/sql?

1106

what is table? : Sql dba

1109

What is a memo field?

1019

What is trigger types in sql?

1046

List out the acid properties and explain?

1018

In what condition is it good to disable a trigger?

1073