select distinct sal from emp e where 2=(select count(distinct sal) from em

how to find the second highest salary from emp table?

Question Posted / chiru

Answer Posted / chiru

select distinct sal from emp e where 2=(select
count(distinct sal) from emp where e1.sal>e.sal) order by
sal desc;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can a table have no primary key?

1010

What is trigger point?

950

What is rename command in sql?

953

What found sql?

898

What is rank dense_rank and partition in sql?

976

Explian rowid, rownum?

960

What are different types of tables in sql?

941

what is the different between now() and current_date()? : Sql dba

938

When should I use nosql database?

946

Is it possible to read/write files to-and-from PL/SQL?

1039

What is a relationship and what are they?

1049

How can get second highest salary in sql?

911

What is a natural join sql?

922

Write the command to remove all players named sachin from the players table.

1124

What is a data definition language?

1029