how to find the second highest salary from emp table?
Answers were Sorted based on User's Feedback
Answer / vinod
SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT
MAX(SAL) FROM TEST_123)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / udayalakshmij
select emp_name,max(salary) from emp except(select max(salary) from emp);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amarendra swain
select max(sal) from employee
where sal not in (select max(sal) from employee )
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shankar panda
SELECT DISTINCT(E.SALARY) FROM EMPLOYEES E WHERE 2=(SELECT COUNT(DISTINCT D.SALARY) FROM EMPLOYEE D WHERE D.SALARY >= E.SALARY)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sreenadh reddy
select max(sal) from emp where sal <(select max(sal) from
emp)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bharath konegadde
Select Emp_Name from emp_table where Id=(Select Emp_Id from Salary Order By salary Desc limit 0,1)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chiguru&
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohan rathour
select max(e1.salary) from Emp_table e1 where e1.salary not
in (select max(e2.salary) from Emp_table e2 )
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / harish
select * from emp where 2=(select count(distinct sal) from emp s where s.sal>e.sal
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / manikishore
select * from emp e where
2 =(select count(distinct sal) from emp where e.sal<=sal);
//if you want to retrieve 3rd max(sal) then you can use 3 in place of 2,,,like that for so on..
Is This Answer Correct ? | 1 Yes | 1 No |
How subquery works in sql?
What is java sql package?
how to shut down the server with 'mysqladmin'? : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
What are the differences between implicit and explicit cursors?
What is exit statement?
What is the difference between an inner and outer join?
What is audit logout in sql profiler?
How do I run a script in sql developer?
What is the difference between the implicit and explicit cursors?
Why should I use postgresql?
What is mutating error?