Write a query to find second highest salary of an employee.
Answer Posted / girase hitendrasing a.
select * from Employees where Salary in (select top 1
salary from (select distinct top 2 salary from employees
order by salary desc) order by salary asc)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Tell us how can we handle web-based pop-up?
What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
What are the advantages of manual testing and automated testing?
How do you select which automation tool is best suited for you?
What are the different types of an automation tool that you are aware of?
Describe some problem that you had with automating testing tool.
what is the difference between keyword driven frame work and data driven frame work.
2. How you will collect a module from the version?
Explain me how do you send enter/tab keys in webdriver?
How can we make one test method dependent on other using testng?
What are Keyword and Data driven frameworks in Selenium RC
What are the types of the framework used in software automation testing?
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
Which package can be imported while working with webdriver?
Hi all, Do anyone have the experience in PDF Document Automation using OLE objects and methods? If so suggest the best websites for source. Thanks :-)