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
Tell me how can you switch back from a frame?
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
Do you know what is a data-driven framework?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
What is the purpose of deselectall() method?
whether flash selenium supports to test Gaming application? like follows: identifying the images, dynamic animations, Dynamic value changes field and win conditions etcc..,
What are the main attributes of test automation?
How do we Test the C++ and Unix Application Using Automated Tool.
How do select which automation testing tool is the best for you?
Can you explain data-driven testing?
What is tree view in automation testing?
Explain some automation testing tools.
Tell us what is the alternate way to click on login button?
What kind of tests should not be automated?
Highlight attributes of good framework?