Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126130 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / kapil deep
SELECT * FROM (SELECT * FROM emp_t WHERE ROWNUM < 3 ORDER
BY salary) WHERE ROWNUM < 2
above query work fine for oracle.
Taking 3 as N give u 3-1=2 i.e 2nd highest
4-1=3 gives u 3rd highest
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Hello, Is there any source from which i can get any live tutorial or trial of Automation tools?? Also i have a query that is there any certification course or exam available for Automation tools QTP and QC?
Tell me how would you test your own element locator?
What is the deference between automation tools and management tools?
Elaborate the situation where automation testing can’t be used for agile methods?
What are the 5 common software development problems solutions?
How does load testing work for websites?
Hi, here r some questions, which were asked in Ekaplus, plz process these questions. 1. How we connect with the version?
Highlight attributes of good framework?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
Tell me what is the testng.xml file used for?
When is automation testing useful?
why we cannot apply check points in compile modules?
Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
Discuss the economics of automation and the role of metrics in testing.
