Write a query to find second highest salary of an employee.
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 |
in my application i am getting different errors at same place. how i capture that errors using less code in qtp.
which is the best online training website?
What are the disadvantages of Hybrid framework
1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: “test scenarios” & “test approch”: points)
why we cannot apply check points in compile modules?
What skills needed to be a good test automator?
how can we exactly identity whether that is manual or automation testing? and give any ex script
Hi, Can anyone please tell me which Test Automation tool can be used for : 1. Web based testing 2. .Net (C#) applications 3. Mobile applications (PDA)
Hi friends please tell me regardinr to QTP descriptive programming. if any materials are there suggest me. or if you have please give me. thank u waiting for reply
Describe some problem that you had with automating testing tool.
What are the limitations of automating software testing?
What is the purpose of the wrun.ini file?