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 |
How do you connect Data base from selenium
What are the different types of testing framework techniques?
What kind of tests should not be automated?
pls suggest me a good institute for loadrunner in hyderabad also what about a practice project?
worksoft automation tool how do you create process ?
i have file name called add.sh how to run and where to run this shell script file???
What are principles of good testing scripts for automation?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
I want online Training for selenium web driver. please can you send any details?
Hi Can anyone tell me the site wherefrom I can Install latest version of QTP on my PC?
i am looking for HP QTP automated testing software, do you offers reselling this software or should i directly purchase with HP
How do you identify the test cases which are suitable for automation?