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

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

How many tables can you join in sql?

0 Answers  

What is NOCOPY?

6 Answers   DELL,

How to download oracle sql developer?

0 Answers  

What is $$ in sql?

0 Answers  

What are three advantages to using sql?

0 Answers  

Does a join table need a primary key?

0 Answers  

What are the advantages of VIEW?

5 Answers  

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

What are the methods of filing?

0 Answers  

Why is %isopen always false for an implicit cursor?

0 Answers  

Is primary key clustered or nonclustered?

0 Answers