Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130582 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 |
i want to pass parameters with some values in the same test. How to call the parameters in the test and to associate it
Tell me an example of the languages supported by webdriver?
What is the purpose of the testing?
I heard that there is a test management system that makes tracking metrics an easy task. I would like to know more about it. Please guide me.
Hello, Is there any source from which i can get any live tutorial or trial of Automation tools?? Also i have a query that is there any certification course or exam available for Automation tools QTP and QC?
Explain what is a relative xpath?
Explain Bug Life Cycle and expalin briefly each 'Status' also
What are the references for TSL functions.? Could anybody suggest me recommended book for Test Script Language.
What is test driven development?
How to find that tools work well with your existing system?
plz explain QTP real time work( Means where you store scripts and how u access scripts next day? where those activities we are maintaining, If By usig VSS how the process in going on , plz explain briefly?
What is the difference between close and quit command?
WinRunner 
