select * from emp where 2=(select count(distinct sal) from emp s where s.sa

how to find the second highest salary from emp table?

Question Posted / harish

Answer Posted / harish

select * from emp where 2=(select count(distinct sal) from emp s where s.sal>e.sal

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is coalesce in sql?

1130

Is sql considered coding?

1088

What normalization means?

1014

How do I turn a list into a table?

1007

Can you skip header records while loading? : aql loader

1100

What are the advantages of sql?

1098

Name three sql operations that perform a sort.

1062

how to convert character strings to numeric values? : Sql dba

1162

What has stored procedures in sql?

1098

What is the use of nvl function?

1239

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

1105

what are the properties and different types of sub-queries? : Sql dba

1072

which types of join is used in sql widely? : Sql dba

1028

How do you modify a trigger?

980

Can we join 3 tables in sql?

1106