select distinct a.sal from emp a where n=(select count(distinct b.sal) fr

how to find 2nd highest salary in random database salary of employer.....

Question Posted / rajasekhar.s

Answer Posted / rajasekhar.s

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Does adding an index lock a table?

1002

Does mysql support nosql?

963

What is meant by mysqli?

956

Is mysql same as mariadb?

949

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1431

What is auto increment in mysql?

1014

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1154

Is mysql better than oracle?

991

How to use 'mysql' to run sql statements?

1167

Does mysql use t sql?

1026

How big is a blob mysql?

937

Can we store files in mysql?

975

If you wish to encrypt the username and password using php, how will you do that?

1068

How do I restore a mysql database dump file in linux?

1033

What are the advantages/disadvantages of mysql and php?

999