Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128348 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mitul deshmukh
Select Salary
from Employee emp
where
2 = Select Count(Salary) from Employee emp1
Where
emp.Salary >= em1.Salary))
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajay
SELECT * FROM employee WHERE salary=(SELECT MAX(salary) FROM employee WHERE employee.salary <
(SELECT MAX(salary) FROM employee))
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishnadevi
select max(sal) from emp where sal not in (select max(sal)
from emp
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / selvaraj
select max(salary) as salary from employee where
salary<(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / subash chand
SELECT max(salary) FROM Employee WHERE Employee.salary <
(SELECT max(salary) FROM Employee);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nitin shrivastava
SELECT MAX(esal) AS salary
FROM Emp
WHERE (esal <
(SELECT MAX(esal) AS Expr1
FROM Emp AS Emp_1))
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nitin shrivastava
SELECT MAX(esal) AS Expr1
FROM Emp
WHERE (esal NOT IN
(SELECT MAX(esal) AS Expr1
FROM Emp AS Emp_1))
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manoj
Select max(salary) from emp where salary NOT IN (Select max
(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dyson
select * from employee where
salary=(select max(salary) from employee where salary <(select max(salary) from employee))
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aarti
select * from employees
where salary = (select mnin(salary)from (select salary from
employees where rownum <= 2 order by salary DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the General Process for Load Test..I mean General Steps?
What are the main benefits of test automation?
Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?
Explain me what is the difference between setspeed() and sleep() methods?
if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?
On what basis you can map the success of automation testing?
What are the types of the framework used in software automation testing?
Are reusable test cases a big plus of automated testing and explain why.
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
How many test cases have you automated per day?
What are the main attributes of test automation?
Hi, here r some questions, which were asked in Ekaplus, plz process these questions. 1. How we connect with the version?
WinRunner 
