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 |
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
Which is better statement or preparedstatement?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is #table in sql server?
what's new in sql server 2016?
How do you start single user mode in clustered installations?
Explain identity in sql server?
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
How to create a new schema in a database?
Difference Between varchar and nvarchar datatype?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
can you any body tell me which service pack is installed in the sql server?