Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126727 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajeshraajan
SQL Server ( For 2nd max Salary )
---------------------------------
select Min(salary) from
( Select Top 2 salary from
( Select distint salary from Employee Order by
salary Desc ))
with this query we can find n th salary.
if am wrong plz correct me.
thx
| Is This Answer Correct ? | 53 Yes | 95 No |
Answer / lia
select employee_name
from employee
order by salary desc
where ROWNUM=2
| Is This Answer Correct ? | 31 Yes | 83 No |
what is are the difference between qtp and selenium ?
Tell me the fundamental difference between xpath and css selector?
How can u enter text in one particular text box? if one webpage contain multiple text boxes, all text boxes with same properties there in no index and Location properties
What is Ticketing tool? Has it any other names? What is the purpose of this?
How to decide the tool that one should use for automation testing in their projects?
8. How we test web based application
How to select an automation tool best matched for your project?
Does automation replace manual testing?
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
worksoft automation tool how do you create process ?
How to find that tools work well with your existing system?
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
WinRunner 
