Write a query to find second highest salary of an employee.
Answer Posted / saima
1.
SELECT * TOP 1 from
(Select Top 2 from employee Order By Salary desc)
order By salary desc
2.
SELECT * from
(Select Top 2 from employee Order By Salary desc)
where salary <max(salary).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is test tool?
Hi everyone, Are you looking for "worksoft certify" automation tool training online? We have experienced corporate Worksoft certify trainers. We also provide support Worksoft certify automation issues. Please contact us Automationsolutions@yahoo.com
Is automation testing a complete replacement for manual software testing?
What is test automation or automation testing?
Explain me how to check if an element is visible on the page?
What are the types of the framework used in software automation testing?
Please explain what is a relative xpath?
What is testng and why is it better than junit?
Hi All, Is there any free automation tool for windows application and it's easy to use? I usually take a lot of time to regression test my application when there is a new build on live environments (about same 10 environments) I wish I know a automation tool to regression test and ofcourse it's free, easy to use (maybe using C#) Could anybody can advise to me a tool like that? I very appreciate ^^
Why do you want to keep this kind of information in a separate file and not directly in the code?
How to check if an element is visible on the page?
Define sdlc in testing.
did anybody take online training from Mind Q systems hyderabad? please share your experience. thanksĀ
Hi, here r some questions, which were asked in Ekaplus, plz process these questions. 1. How we connect with the version?
Please explain what is the difference between findelement () and findelements ()?