Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126166 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / saima
1.
SELECT * TOP 1 from
(Select Top 2 from employee Order By Salary desc)
order By salary desc
2.
SELECT * from
(Select Top 2 from employee Order By Salary desc)
where salary <max(salary).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain me what the webdriver supported mobile testing drivers do you know?
Tell me how could ajax controls be handled in webdriver?
Simplify the term defect severity.
IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?
Tell me how can the user get a text of a web element?
How will you automate basic “login” functionality test cases for an application?
Do you know what is a data-driven framework?
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 methods of robot class do you know?
what r the diffence between QTP 8.2 & QTP9.0?
Types of F/w in Automation
What kind of tests should not be automated?
Explain some automation testing tools.
Explain what is a relative xpath?
Differentiate between hdam and hidam database?
