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

List the different types of normalization?

945

How to create a test table in your mysql server?

1046

Explain the architecture models of SQL Server?

2336

Explain about reporting services of MYSQL?

1066

How do I run mysql on a mac?

968

How to use mysqldump to create a copy of the database?

1051

What is blob in mysql?

1016

How to use like conditions?

985

Does mysql use tcp or udp?

919

What is the maximum connection pool size?

972

What is heap table in mysql?

973

How set mysql root password?

916

What is row level locking?

924

Why do we use the mysql database server?

1048

What is the datatype of image in mysql?

918