Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where

how to find the second highest salary from emp table?

Question Posted / jyotiprokash

Answer Posted / jyotiprokash

Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where e1.salary<e2.salary)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of stored procedures?

1044

which tcp/ip port does sql server run on? : Sql dba

1026

What is anonymous block in sql?

1120

How to select unique records from a table?

1055

What do we need to check in database testing?

1017

what are integrity rules?

1022

Can one improve the performance of sql*loader? : aql loader

1046

What is auto increment feature in sql?

1122

What is the use of <> sql?

978

how to drop an existing table in mysql? : Sql dba

1042

What does stand for in sql?

964

How is pl sql different from sql?

1086

What is a system versioned table?

980

How to sort the rows in sql.

1073

What is dml statement?

954