Write a query to find second highest salary of an employee.
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
Have you completed the cps exam? Which one?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
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.?
Explain me which web driver implementation is the fastest?
Explain what is a relative xpath?
Tell me what are pros and cons of automating tests at ui layer?
can any one tell me the examples of white box testing
What all things can you automate?
Tell me what is automation testing?
Why automation testing?
Explain load testing on websites?
What is testng and why is it better than junit?
How do you choose which automation tool is best for your specific scenario?
wat is database testing....how to develop data driven framework in selenium enviromnent. please explaing in detail