Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126041 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / raaghav
Try this query
===================
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 '(n is always greater than one)
E.g.:-
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
Tell me how would you test your own element locator?
Do you know what is functional testing?
What is junit? And what is junit annotation?
Can you list some other automation testing tools that you are familiar with?
How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.
Explain me which web driver implementation is the fastest?
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
On what basis you can map the success of automation testing?
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
What should you do after finding a bug?
What is a critical bug in a testing field?
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
What is self-referencing constraint in mainframe development?
What is test automation or automation testing?
