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 pl sql in dbms?

949

Why do we use subquery?

1010

how to shutdown mysql server? : Sql dba

1096

Compare sql & pl/sql

1131

How do you identify a primary key?

1062

What are the features of pl sql?

1064

what are dynamic queries in t-sql? : Transact sql

1019

Is sql considered coding?

1043

What is gpt format?

936

Can a foreign key be a duplicate?

906

Can you do multiple joins in sql?

1048

Why stored procedures are faster than query?

1021

What is offset in sql query?

1104

how to check server status with 'mysqladmin'? : Sql dba

1074

What are literals in sql server?

1164