select name, sal from (select name,sal from emp where sal<(select max(sa

how to calcuate the second highest salary of he employee

Question Posted / lalit

Answer Posted / lalit

select name, sal from (select name,sal from emp where sal<(select max(sal) from emp) order by sal desc)where rownum=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we use procedures in sql?

1089

how many sql ddl commands are supported by 'mysql'? : Sql dba

1025

What is scalar data type in pl sql?

1074

How to select random rows from a table?

1081

Is primary key is clustered index?

1002

Compare sql & pl/sql

1143

Does sql view stored data?

962

How many types of cursors are available in pl/sql?

1111

Explain raise_application_error.

1100

Why do we use cursors?

991

what is the difference between blob and text? : Sql dba

1023

Which data type is a composite type?

991

Where is all the data on the internet stored?

1015

Which is better stored procedure or query?

957

how to show all tables with 'mysql'? : Sql dba

1118