Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128912 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 the Driver sheet??
Which package can be imported while working with webdriver?
What are the 5 common software development problems solutions?
What testing activities you may want to automate?
i have 100 check box in a link,out of 100 check box in 25 check box their written qtp(any where i dont know),i have to select first check box where 1st qtp found.
Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?
Which is the best testing institute for Selenium training in Hyderabad.
Tell me what kind of tests should not be automated?
Tell me how can we find the value of different attributes like name, class, value of an element?
Hi, Pls let me know good institutes/trainer for SAP TAO. Any help/inputs is very much appreciated. Thanks.
what is meant by keyboard driven test?
How do you select which automation tool is best suited for you?
WinRunner 
