select max(sal)from emp e1 where 2<=(select count(*) from emp e2 where

Write a query to find second highest salary of an employee.

Question Posted / vittal

Answer Posted / vittal

select max(sal)from emp e1 where 2<=(select count(*) from
emp e2 where e1.sal <= e2.sal);

Is This Answer Correct ?

66 Yes

38 No

Please Help Members By Posting Answers For Below Questions

What is in-house tool?

976

wat would be the parameteries for ul testing for web applilcation

2096

What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...

1907

can any one tell me the examples of white box testing

2413

What are the steps involved in the automation process ?

1215

Generic function for selecting a Radio Button in a Dialog

2353

Tell me how would you test your own element locator?

942

Tell me what is the purpose of getoptions() method?

909

Mention a few good practices while performing automation testing.

917

What is functional and regression testing?

1042

5. What are the tests you are conducting through winrunner?

2379

IS DATA INTEGRITY TESTING AND INTEGRATION TESTING ONE AND THE SAME?IF DIFF CAN U SPECIFY THE DIFFERENCES

2034

What is open source tool and give example?

921

Which protocol cam be used to makw jdbc connection woth loadrunner

951

In general, how do you see automation fitting into the overall process of testing?

1981