how to find the second highest salary from emp table?
Answers were Sorted based on User's Feedback
Answer / winnie
select max(sal) from emp
where sal not in (select max(sal) from emp )
Is This Answer Correct ? | 1090 Yes | 131 No |
Answer / gayathri
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
Is This Answer Correct ? | 754 Yes | 97 No |
Answer / gourvendra singh
Please put the below query, u will get the second highest
salary of the table :---
select sal from(select sal from
(select distinct sal from emp order by sal desc)
where rownum<=2 order by sal asc)
where rownum=1;
Is This Answer Correct ? | 488 Yes | 264 No |
Answer / nalini
Follow the following Query, You get the second highest
salary.
SQL> Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
SQL> Enter the level No=2 (Here enter 2 manually)
Then you will get the 2nd highest salary.
If you want 3rd Highest salary, then enter level no=3.
Is This Answer Correct ? | 208 Yes | 105 No |
select max(sal) from emp where sal < (select max(sal) from
emp)
Is This Answer Correct ? | 86 Yes | 16 No |
Answer / anuj maheshwari
select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));
Is This Answer Correct ? | 34 Yes | 5 No |
Answer / erp_guns
SELECT MAX(sal) from emp a where &n=(select COUNT(DISTINCT
(SAL)) from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 39 Yes | 22 No |
Answer / shiva kumar
select max(salary) from table01
where salary <(select max salary from table01)
in mainframe env
Is This Answer Correct ? | 27 Yes | 13 No |
second method is
select sal from emp e1 where 2=(select count(distinct(sal))
from emp e2 where e1.sal<=e2.sal);
Is This Answer Correct ? | 35 Yes | 22 No |
What is rowtype?
what is global temporary tables and how use that tables in pl/sql packages
What has stored procedures in sql?
What is indexes?
What are wait events. Describe the wait event tables.
Is nosql relational?
What is materialised View?
Difference between views and materialized views?
what are the advantages a stored procedure? : Sql dba
What is the Diff b/w Constraints and Trigeer
what is dbms? : Sql dba
Is t sql a programming language?