select *from emp e1 where &n =(select count(*) from emp where sal >

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

Question Posted / sweety spear

Answer Posted / sweety spear

select *from emp e1 where &n =(select count(*) from emp
where sal >= e1.sal);

Is This Answer Correct ?

13 Yes

3 No

Please Help Members By Posting Answers For Below Questions

I am testing a GIS based application so Can anyone tell me which automation testing tool is best for this application?

2959

Explain about basics of rational robot - ibm test automation tool?

1152

Which test cases can be automated?

1049

Can we do automation testing without a framework? If yes, then why do we need a framework?

1258

What should you do after finding a bug?

1174

Give some examples for performance test tools?

1120

Tell us how to select a value in a dropdown?

1059

how to write ciertification in QTP?

2190

What is the scripting standard while performing automation testing?

1169

pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?

2355

wat is database testing....how to develop data driven framework in selenium enviromnent. please explaing in detail

2129

Tell me what kind of tests should not be automated?

1030

Explain me what is a framework and what are the frameworks available in rc?

1044

how to use regular expression in Test Complete Functional tool

5501

What is the purpose of getoptions() method?

1087