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
how to write ciertification in QTP?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
suggest me the free online books on software testing?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
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
What is extreme programming and what has it got to do with testing?
Do you think that testing can be done only at the ui level?
How would you test your own element locator?
Explain me what is the difference between setspeed() and sleep() methods?
List some advantages and disadvantages of manual testing.
Can you explain data-driven testing?
hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
Is automation testing a black box testing or white-box testing?
Where you have applied oops in automation framework?