Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130599 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / rajeshraajan
SQL Server ( For 2nd max Salary )
---------------------------------
select Min(salary) from
( Select Top 2 salary from
( Select distint salary from Employee Order by
salary Desc ))
with this query we can find n th salary.
if am wrong plz correct me.
thx
| Is This Answer Correct ? | 53 Yes | 95 No |
Post New Answer View All Answers
Mention a few good practices while performing automation testing.
if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?
Have you completed the cps exam? Which one?
Tell us how to select a value in a dropdown?
List the five essential types of test steps?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
Explain some disadvantages to manual software testing?
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... :(
Tell me what is tsl? What 4gl is it similar too?
How can the user get a text of a web element?
What are the advantages of manual testing and automated testing?
Give some examples of priority – severity defect levels.
Explain me what are the main advantages of automation testing?
Explain me what is a framework and what are the frameworks available in rc?
What is test tool?
