select ename,esal from (select ename,esal from hsal order by esal desc

how to find the second highest salary from emp table?

Question Posted / rameshwari

Answer Posted / rameshwari

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;

Is This Answer Correct ?

123 Yes

242 No

Please Help Members By Posting Answers For Below Questions

Explain the advantages and disadvantages of stored procedure?

1151

How sql query is executed?

1136

what is the difference between $message and $$message? : Sql dba

1001

What are the three pl sql block types?

1010

Is postgresql a nosql database?

1165

Does sql profiler affect performance?

998

what are the differences between require and include, include_once and require_once? : Sql dba

1028

Can we use join in subquery?

1100

What is sql used for?

1129

what is offset-fetch filter in tsql? : Transact sql

952

How to display the records between two range in Oracle SQL Plus?

1148

What is the usage of distinct keyword?

1068

How do I install sql?

1002

What is trigger in sql? Explain

999

Explain unique key in sql.

1017