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 |
I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this
What is mean by ARGO testing? can any one please explain
If i am doing the automation of test suites in a project. Then what will be the system interfaces for that?? The tools I am using or something else... please help..!!
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
How you will evaluate the tool for test automation?
Tell us the difference between assert and verify commands?
what is 2 tier and 3 tier application.
Bug report formate in bugzilla
How did you use WR in your project? Please can i get in detail answer for this?
Hi There...I am guy from Mumbai working as a Software Tester (Manual). I really want to learn automation with live projects. Could anyone help me to learn automation or give tutions. I do not like the way the Software testing Institute provides training. Please can anyone help me out. And also I want to appear for ISTQB exam...please help me out....Thanks in advance.. My ID is amaan_sbp@yahoo.com amaanactually@gmail.com Phone no: 9323543045
How do you choose which automation tool is best for your specific scenario?
is there any Rational Functional Tester certification questions available?