Write a query to find second highest salary of an employee.
Answer Posted / barochia dharmesh
select Income from (
select Rank() over(order by Income desc) topRecord, Income
from (select distinct Income from tblName) tbl ) tbl2
where topRecord = 2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Give some examples for functional & regression test tools?
Hi everyone, Are you looking for "worksoft certify" automation tool training online? We have experienced corporate Worksoft certify trainers. We also provide support Worksoft certify automation issues. Please contact us Automationsolutions@yahoo.com
What kind of tests would you automate?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
Explain me what is testng and why is it better than junit?
What are the references for TSL functions.? Could anybody suggest me recommended book for Test Script Language.
Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?
Do you know what is a data-driven framework?
wat is database testing....how to develop data driven framework in selenium enviromnent. please explaing in detail
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.
What are the risks associated in automation testing?
how to map requirements& test cases in quality center ???
Explain what is the hybrid framework?
how to use regular expression in Test Complete Functional tool