Write a query to find second highest salary of an employee.
- 72 Answers
- 109364 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / aarti
select * from employees
where salary = (select mnin(salary)from (select salary from
employees where rownum <= 2 order by salary DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
suggest me the free online books on software testing?
What are the different types of scripting techniques for automation testing?
Explain me what is testng and why is it better than junit?
Tell us what automation tools could be used for post-release validation with continuous integration?
What all different approaches can be used for designing an automation solution?
Tell me how could the web element attributes be inspected in order to use them in different locators?
How can we make one test method dependent on other using testng?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
Can anyone tell me the correct answer of below question....it is about Bugzilla tool. When bug will find out at the time of executio where it will save or what is the location of bug??
is there any one got offer from snapdeal?
Do you know what is robot api?
Stop automating the tests which run once?
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
Explain me what is the difference between setspeed() and sleep() methods?
how to use regular expression in Test Complete Functional tool
