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

Is sql a microsoft product?

997

what is the difference difference between procedure and packages

10549

How do you run a query?

1051

Why is %isopen always false for an implicit cursor?

1153

Can we use delete in merge statement?

1101

How to display the current date in sql?

1129

What is mutating sql table?

1160

What is a primary key called that is made up of more than one field?

1393

Is drop table faster than truncate?

1051

How can you create an empty table from an existing table?

1129

What are inner and outer joins examples of both?

1010

is mysql query is case sensitive? : Sql dba

1164

Why coalesce is used in sql?

1069

Is sql a scripting language?

1086

how can we find the number of rows in a table using mysql? : Sql dba

1131