Write a query to find second highest salary of an employee.
Answer Posted / muralidhara(minchu)
Select * from epm A where &(n-1)=(select count(*) from emp
B where A.sal < B.sal);
Try this it will work,this will give nth salary ie if u
enter 2 this will give second highest sal
| Is This Answer Correct ? | 13 Yes | 22 No |
Post New Answer View All Answers
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
Tell us how can we handle web-based pop-up?
Tell us what is the alternate way to click on login button?
What is self-referencing constraint in mainframe development?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
Explain some disadvantages to manual software testing?
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.
Tell us which package can be imported while working with webdriver?
Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru
Tell me the fundamental difference between xpath and css selector?
What all different approaches can be used for designing an automation solution?
Tell me how can the user get a text of a web element?
what is aom and how to add object repository? i am very new to QTP please help me
what is the difference between keyword driven frame work and data driven frame work.