To find second largest salary in Employee table
Answers were Sorted based on User's Feedback
Answer / anil
select max(salary) from tbl_employee where salay <(select max(salary) from tbl_employee)
Is This Answer Correct ? | 30 Yes | 6 No |
Answer / saravanakumar
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / ram
select *from emp e where &n in(select count(distinct sal)
from emp m where e.sal<=m.sal);
which will ask's u like :
enter the value for n : 2 (enter 2)
gives u second highest.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / amit
select max(salary) from employee where salary != (select max
(salary) from employee)
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vikas kant
select Top 1 salary from emp_Table where salary in(select
Top 2 Salary from emp_Table order by salary desc)
Is This Answer Correct ? | 6 Yes | 4 No |
Answer / zulfikar ali
SELECT MAX(SALARY)
FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT TOP 1 SALARY FROM EMPLOYEE ORDER
BY SALARY DESC)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / padmapriya
Thanks every one who replied for my question.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / v rajkumar
Select min(salary)FROM emp WHERE salary IN (SELECT distinct
TOP 2 salary FROM emp ORDER BY salary desc)
OR
Select top 1 salary from (select distinct top 2 salary from
emp order by salary desc) emp order by salary
OR
select max(salary) from emp where salary <(select max
(salary) from emp)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / satish
select salary from emp_Table_1 where 2= (select count(*)
form emp_Table_2 where emp_Table_2.salary < emp_Table_1.salary)
-satish
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mohammad murtuza ali
select salary from employeetable where empsal is < max(salary)
Is This Answer Correct ? | 4 Yes | 4 No |
i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com
tell me the disaster recovery plan
What are the five characteristics of good data?
Define outer join?
What is the difference function and stored procedure?
Is it possible in sql table to have more than one foreign key?
what is macro?
5 Answers Excel, Global Innovation, Wipro,
what is extended StoreProcedure ?
Where is my database stored on the hard disk in ms sql server?
When we can say that is in BCNF?
What are different types of statement?
Can you explain about buffer cash and log cache in sql server?