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

Given an employee table, how would you find out the second
highest salary?

Question Posted / ravikumar

Answer Posted / ravikumar

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a database development?

977

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1026

In which database can extended stored procedures be added?

912

Explain the cube operator?

1020

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4020

Explain about query and reporting.

2102

What are the types of database model?

1107

How to combine two function together?

2142

How you can make a parameterized view?

1025

How to replace not in with not exist?

2102

What is database design and development?

1026

How is data stored in dbms?

972

How to read and create .LDC data files which are used by linguatic dictionary.

2541

Explain about the relational database?

1089

Explain about a primary key?

992