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 table? : Sql dba

0 Answers  

What is on delete restrict?

0 Answers  

Why do we need a foreign key?

0 Answers  

Why we use cross join?

0 Answers  

Is sql easier than java?

0 Answers  

Explain what is rdbms?

0 Answers  

What is data control language (dcl)?

0 Answers  

What does cursor do in sql?

0 Answers  

What is sql catalog?

0 Answers  

Is like operator in sql case sensitive?

0 Answers  

What is attribute indicator in pl sql?

0 Answers  

How do you remove duplicate records from a table?

0 Answers