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 the difference between functions, procedures, and packages in pl/sql?

0 Answers  

How to download oracle sql developer?

0 Answers  

Explain 3 basic parts of a trigger.

0 Answers  

What is sqlcommand?

0 Answers  

How do I trace sql profiler?

0 Answers  

Can there be 2 primary keys in a table?

0 Answers  

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

what is a join? : Sql dba

0 Answers  

How do you modify a table in sql?

0 Answers  

What is varchar used for?

0 Answers  

How to combine two stored procedures in sql?

0 Answers  

What is sql query limit?

0 Answers