Write a query to find second highest salary of an employee.
- 72 Answers
- 109452 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
Do you know what is a xpath?
Give some examples for test management tools?
What is testng and why is it better than junit?
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
Explain me what the webdriver supported mobile testing drivers do you know?
is there any one got offer from snapdeal?
Can you achieve 100% automation?
Please explain what is a relative xpath?
When will you automate a test?
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, I wanted to go with TestingDomain-Automation. Regarding this I need to take training on any one tool either WinRunner or LoadRunner. Which is better to get job,having future and takes lesstime with easier***. pls mention one tool name. Basically iam manual test engineer on unix- platform.
How will you automate basic “login” functionality test cases for an application?
How many test cases have you automated per day?
Mention a few good practices while performing automation testing.
What is functional and regression testing?
