select sal from emp where sal=(select max(sal) from emp where sal<(sele

how to calcuate the second highest salary of he employee

Question Posted / shailesh

Answer Posted / shailesh

select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how to fetch alternate records from a table? : Sql dba

1050

Explain isolation levels. : Transact sql

1014

What is a function in oracle pl sql?

975

Are dml statements autocommit?

980

tell us something about heap tables. : Sql dba

1047

Can we use joins in subquery?

1084

What is Collation Sensitivity ? What are the various type ?

901

What is before trigger?

943

Why is sql better than hql?

920

What are different clauses used in sql?

1066

Why indexing is needed?

938

What does t sql mean?

895

How to read xml file in oracle pl sql?

859

What is using in sql?

1011

If a cursor is open, how can we find in a pl/sql block?

1103