Answer / winnie

select max(sal) from emp
where sal not in (select max(sal) from emp )

Answer / gayathri

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Answer / bipin

use this query. it works great.

select max(sal) from table_name where sal<(select max(sal)
from table_name)

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;

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.

Answer / muhammed zaheer

select max(sal) from emp where sal < (select max(sal) from
emp)

Answer / anuj maheshwari

select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));

Answer / erp_guns

SELECT MAX(sal) from emp a where &n=(select COUNT(DISTINCT
(SAL)) from emp b where a.sal<=b.sal)

Answer / shiva kumar

select max(salary) from table01
where salary <(select max salary from table01)

in mainframe env

Answer / radha sri seshu

second method is
select sal from emp e1 where 2=(select count(distinct(sal))
from emp e2 where e1.sal<=e2.sal);

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

What are pl sql data types?

0 Answers  

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

what are Dynamic SQL statements?

9 Answers  

What is having clause in sql?

0 Answers  

What is before and after trigger?

0 Answers  

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

What is sql*plus?

0 Answers  

What is diff between bulk collect and forall

3 Answers   Metric Stream,