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

Explain what a database is?

1085

Explain about network model?

1051

Explain about post-relational databases?

1080

Who are end users in dbms?

1035

How to use timestamp datatypes

2079

What is an application role and explain a scenario when you would use one?

1058

How can I detect whether a given connection is blocked?

1120

How is data stored in dbms?

1010

What is data modeling with example?

1059

How to replace not in with not exist?

2178

Which four data types cannot be used as a return type from a user-defined function?

1063

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2266

What are the three types of database design?

1085

State the acid rules?

1181

How can you fix a poorly performing query?

1256