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

What do you understand by case manipulation functions?

1040

What pl/sql package consists of?

1090

Does inner join remove duplicates?

946

What are the benefits of triggers?

1175

What can you do with pl sql?

1098

What is minus?

1014

Which is faster count (*) or count 1?

1038

Where is sql database stored?

988

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

970

explain the delete statements in sql

1066

What is sql resultset?

992

what is meant by urlencode and urldocode? : Sql dba

1180

Is a view faster than a stored procedure?

976

what is normalization? : Sql dba

1089

Advantages and disadvantages of stored procedure?

1123