Write a query to find second highest salary of an employee.
Answer Posted / amit rajput
Select Min(NetAmount) from (Select Distinct Top 9 NetAmount
from vw_im order by NetAmount desc) a
This will give you 9th highest Salary
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
When you will not automate testing?
What is junit? And what is junit annotation?
How to Rcognize the Objects in the Web Page Dialog Using QTP
Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru
Tell us what methods of robot class do you know?
What are the limitations of automating software testing?
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
What are the advantages of test automation?
When will you not automate testing?
notice the distinction between data driven testing and retesting?
test cases test wheather window? test cases to test calculaor? test cases to test a reverse string program? test cases to test program{ int.parse(sting str) $return (int)}? test cases to test program{display string length}?
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
What kinds of annotations are used in testng?
How do you plan test automation?
What is hybrid automation?