select distinct(sal) from emp a where 2=(select count(distinct(sal)) from e

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

Question Posted / omkar hendre

Answer Posted / omkar hendre

select distinct(sal) from emp a where 2=(select count(distinct(sal)) from emp b where a.sal <=b.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is date functions?

1024

what are local and global variables and their differences? : Sql dba

1067

Where can I learn sql for free?

981

Are stored procedures compiled?

915

Which version of sql do I have?

1050

Can we join more than 2 tables in sql?

1015

How to move files from one directory to another in pl sql?

1187

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

1065

How do I delete a trigger?

961

What is a scalar value in sql?

1070

How do you clear the screen in sql?

1064

What are the qualities of 2nf?

1035

what is meant by nl2br()? : Sql dba

1031

What is sqlca in powerbuilder?

1000

Is nosql relational?

938