Answer / bibin__edappal

select salary from empTable where salary = (select
max(salary )from empTable where salary < (select max(salary
) from empTable))

OR

select salary from empTable where salary = (select
max(salary )from empTable where salary NOT IN (select
max(salary ) from empTable))

Answer / chandu

select max(sal)from table name where sal<(select max sal
from table name)

Answer / rajat

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

Answer / abhi

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

OR

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

OR

select max(sal)from emp where sal != (select max(sal)from emp)

Answer / rajiv singh

select max(department_id) from departments where
department_id <(select max(department_id) from departments);

Answer / harish

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

Answer / hari chaudhary

All My friend use this query then good result of your sql
database find in second or Third last data find.....

Select distinct(salary) From employee E1 Where
(n-1) = (Select Count(Distinct(E2.salary)) From employee E2
Where E2.salary > E1.salary)

Answer / jitendra kumar

select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;

Answer / subrat

SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FROM EMP)

Answer / sagar

if the salary is simple non-duplicate salary, you can use
the below queries:

select max(sal) from emp where sal != (select max(sal) from emp)

you can also try

select sal from (select * from emp order by sal desc) where
rownum = 2

What is not null in sql?

0 Answers  

What operators deal with null?

0 Answers  

Where is sql database stored?

0 Answers  

what is csv? : Sql dba

0 Answers  

Mention what does plv msg allows you to do?

0 Answers  

What is scalar and vector?

0 Answers  

What is vector point function?

0 Answers  

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

In what condition is it good to disable a trigger?

0 Answers  

Is record in pl sql?

0 Answers  

What is group by in sql?

0 Answers  

What is clause in sql?

0 Answers