Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128351 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 / aj.com
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT
MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / shyam
select max(salary) as '2nd Highest Salary'
from Employee a
where 2<=(select count(*) from Currencies b where a.salary
<= b.salary);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nilesh chaudhari
Select max(Salary) as 'Second Highest Salary' from Employee
where USdollar NOT IN
(Select max(Salary) from Employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / saravanan.s
select max(salary) as salaryemp from employee where
employee.salary<(select max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / rajesh kole
SELECT MIN(Sal) FROM Employee
WHERE Sal IN
(SELECT TOP 4 Sal FROM employee ORDER BY Sal DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sup
SELECT TOP 1 salaryamount
FROM (
SELECT DISTINCT TOP 3 salaryamount
FROM mstsalary
ORDER BY salaryamount DESC) a
ORDER BY salaryamount
--sup--
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hardit
select TOP 1[salary]
from(
select distinct TOP 2[salary]
from empTable
order by salary desc
) a
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kedo
select sal from
select * from employee orderby salary DESC
Limit 1,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / harikrishna ravipati
select max(sal) from emp where sal <
(select max(sal) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandramami
SELECT MAX(e.salary)
FROM emp e,emp e1
WHERE e.salary<e1.salary;
| Is This Answer Correct ? | 0 Yes | 0 No |
How did you use WR in your project? Please can i get in detail answer for this?
how to connect qtp to qc. what are the steps ?
Describe some problem that you had with automating testing tool.
What is Database Testing?
How t o create Libreary files on QTP
Is software requirement specification for developer and tester is same?
How you will evaluate the tool for test automation?
What are the risks associated in automation testing?
how can i count the no of edit field in a page and fill the multiple edit field
what is the difference or comparison between QTP and rational? and which tool is better to use?
Have you completed the cps exam? Which one?
What do you like (not like) in this job?
WinRunner 
