Write a query to find second highest salary of an employee.
Answer Posted / shyam
select max(salary) as '2nd Highest Salary'
from Employee a
where 2<=(select count(*) from Currencies b where a.salary
<= b.salary);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Tell me what is the testng.xml file used for?
Where will you maintain information like url, login, password?
what is the difference between keyword driven frame work and data driven frame work.
What type of scenarios can be automated?
Tell us how to select a value in a dropdown?
What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?
How can we make one test method dependent on other using testng?
What kind of tests would you automate?
What is tree view in automation testing?
What are the various kinds of frameworks that can be used in software automation testing?
How to select an automation tool best matched for your project?
What are the pre-requisites to start automation testing?
Do you know what is a xpath?
Can we find all links on a web page?