Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128297 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
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
What is the purpose of deselectall() method?
Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..
hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.
How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.
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
Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?
What are pros and cons of automating tests at ui layer?
VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?
what is the difference between Batch test runner and framework ?
Where to maintain information like login, password and url?
In what condition we cannot use automation testing for the agile method?
Do you know what is robot api?
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
