Write a query to find second highest salary of an employee.
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 |
Name a couple of standard web function found in the function generator?
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
What is meant by the automation framework?
It is a 30 days project & the client is in Singapur and we have to submit daily report regarding 1) What are the completed works, 2) What are the Pending Works ,3) Work planed for next day. You are free to assume regarding the project. can anybody help me to write an email to the client or Senior person who is staying in abroad
Are applications developed in Java, html, servletts client server or web based..
Hi I need the following information about JMeter 1) How many(max) threads(users) can hit the website using Jmeter? 2) How long(in hours) can we run Jmeter for stress test? (Is there any “Memory full” issue if we run for long time?) 3)What typeof sampler to use for clicking on the link?
how to write ciertification in QTP?
Do you know what is selenese?
What is Test strategy documents.
Elaborate the scripting standard while executing testing
Do you know what is a xpath?
Hi, Can anyone please tell me which Test Automation tool can be used for : 1. Web based testing 2. .Net (C#) applications 3. Mobile applications (PDA)