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

How do you choose which automation tool is best for your specific scenario?

546

Tell me an example of the languages supported by webdriver?

666

What is the scripting standard while performing automation testing?

638

Tell us what is junit? And what is junit annotation?

512

What are the advantages of automation testing?

537

What all different approaches can be used for designing an automation solution?

476

What is in-house tool?

544

if i want to use different values in datatable with each iteration of for loop what would i do ??/

1635

Write a short compiled module which selects random numbers?

528

what is aom and how to add object repository? i am very new to QTP please help me

1439

Elaborate the situation where automation testing can’t be used for agile methods?

497

What are pros and cons of automating tests at ui layer?

541

What kind of tests should not be automated?

541

What factors determine the effectiveness of automation testing?

524

What are the primary features of good automation tool ?

570