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

Is mariadb faster than mysql?

965

How we can see all indexes defined for a table in mysql?

936

How much does mysql enterprise cost?

924

How do I create a schema in mysql?

875

What are the advantages of mysql in comparison to oracle?

1027

What is InnoDB?

1103

What is a select query?

858

How do I connect to a mysql database?

931

What is 'mysqlshow'?

1061

How to see table's field formats or description of table .

887

What is innodb mysql?

1084

What is mysql enterprise edition?

911

What is 'mysqlcheck'?

1025

What is the default port of mysql server?

1034

Write a query to fetch duplicate records from a table using mysql?

937