Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128612 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / khurram
The Simplest, easy, Understandable solution is
select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)
Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Tell us which package can be imported while working with webdriver?
What you know about table-driven testing?
What are different coverages in function testing?
hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one
4. How we implement Winrunner,in our project?
Write a short compiled module which selects random numbers?
i need test cases for defect maganement tools
I am testing a GIS based application so Can anyone tell me which automation testing tool is best for this application?
Tell us how do you get the width of the textbox?
How would you test your own element locator?
Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com
how to test an webbased application?
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
List some advantages and disadvantages of automation testing.
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
