Write a query to find second highest salary of an employee.
Answer Posted / deepak falke
3rd highest sal from account :
SELECT TOP 1 Sal FROM account WHERE Sal IN
(SELECT distinct TOP 3 Sal FROM account ORDER BY Sal DESC)
order by sal
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a xpath?
5. What are the tests you are conducting through winrunner?
what r the diffence between QTP 8.2 & QTP9.0?
Elaborate the fields in bug report in automated testing
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
Do you know how to verify if the checkbox/radio is checked or not?
Is ui level testing possible?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932
Explain what sikuli is?
What is test automation?
What are the attributes of a good framework?
Does automation testing have any disadvantages?
What is an automated test script?
What are the different types of scripting techniques for automation testing?