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 ?||1083 Yes||130 No|
Answer / gayathri
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
|Is This Answer Correct ?||749 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)
|Is This Answer Correct ?||488 Yes||264 No|
Answer / nalini
Follow the following Query, You get the second highest
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|
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|
using comand prompt how can import table data and table space with example
What is structural independence and why is it important?
What is meaning of <> in sql?
what is single byte over head in oracle..?
What are Nested Tables? How will u delete 5 rows from Nested Tables
How do sql triggers work?
What is the most common sql injection tool?
What is a design view?
How can we store rows in PL/SQL using array?
What is the purpose of cursors in pl/sql?
what is the difference between sql and t-sql? : Transact sql
Can we insert in view in sql?