Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126139 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / ashish
select salary from
(select dense_rank() over(order by salary desc) as highest, salary from employee)as y
where highest=2
: replace 2 with n.... it will give nth highest salary
: rank() will work correctly only if all the salaries in employee table are distinct.
: dense_rank() will work correctly, does'nt matter salaries are distinct or NOT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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?
how to use regular expression in Test Complete Functional tool
How can the user get a text of a web element?
what types of documents we need to write the nonfuntional test scripts?
On what basis you can map the success of automation testing?
Please explain how to perform load-testing?
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
What are the important modules of an automation testing framework?
What are the types of the framework used in software automation testing?
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines
Which package can be imported while working with webdriver?
Tell us what is junit? And what is junit annotation?
Does automation testing have any disadvantages?
What is junit annotation?
What are the references for TSL functions.? Could anybody suggest me recommended book for Test Script Language.
