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

Answer Posted / murlidhar

select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)

Is This Answer Correct ?    41 Yes 36 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one tell me the examples of white box testing

1999


Please name a couple of standard web function found in the function generator?

513


Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

482


Name the frameworks that are used in software automation testing?

531


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

1986






what is dynamic window and dynamic model ? (worksoft automation tool)

1576


What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain

1492


Tell me the fundamental difference between xpath and css selector?

560


Discuss the economics of automation and the role of metrics in testing.

2032


1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)

1645


What are different coverages in function testing?

602


how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns

1635


What is the difference between continue and next sentence?

521


What are the drawbacks of test automation?

578


Tell me which web driver implementation is the fastest?

517