Write a query to find second highest salary of an employee.
Answer Posted / krishna kishore
SELECT TOP 1 Salary FROM Employee WHERE Salary IN
(SELECT TOP 2 Salary FROM Employee ORDER BY Salary DESC)
I think this would be the simplest way and high performance
query.
waiting for the comments !!!
| Is This Answer Correct ? | 7 Yes | 11 No |
Post New Answer View All Answers
Tell us how can you find if an element is displayed on the screen?
Tell me what are pros and cons of automating tests at ui layer?
When will you automate a test?
Please explain what is a relative xpath?
Explain me what are the main advantages of automation testing?
in keyword driven frame work..where Driver Script is locate? is there any inbuilt script for driver script?who writes the driver script?how to call it any body can tell me with an example...like(yahoo login,inbox, logout).
What are the points that are covered while planning phase of automation ?
How to decide the tool that one should use for automation testing in their projects?
What is mean by ARGO testing? Can you please explain anyone
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
Tell us what is the alternate way to click on login button?
How to check if an element is visible on the page?
What is hybrid automation?
Elaborate the scripting standard while executing testing
what types of documents we need to write the nonfuntional test scripts?