Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128790 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is the difference between findelement () and findelements ()?
How automation process is carried out?
Elaborate the situation where automation testing can’t be used for agile methods?
Do you know how to check if a button is enabled on the page?
What are the points that are covered while planning phase of automation ?
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
Tell us can we find all links on a web page?
Do you know when autoit is used?
what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please
Tell us what automation tools could be used for post-release validation with continuous integration?
How can the user get a text of a web element?
What is vendor tool and give examples?
On what basis you can map the success of automation testing?
Tell me how could the web element attributes be inspected in order to use them in different locators?
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
