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 cursor explain with example?

0 Answers  

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

Does sql full backup truncate logs?

0 Answers  

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

what is the difference between join and union? : Sql dba

0 Answers  

What are the possible values that can be stored in a boolean data field?

0 Answers  

what is data control language? : Sql dba

0 Answers  

What is a unique key and primary key and foreign key?

0 Answers  

How do I run a program in pl sql?

0 Answers  

what is sql? : Sql dba

0 Answers  

tell me about various levels of constraint. : Sql dba

0 Answers