Answer / ashish damohiya

Answer :
Select max(salary) from Emp_Table where max(salary) not in
(Select max(Salary) from Emp_Table)
this sufficient answer.

but there change the format of question that
How to find the second highest salary of each employee form
emp table ?

Answer :

with cte as (
select rank() over(order by emp_name) rank1 , ROW_NUMBER()
OVER(partition by emp_name ORDER BY basic desc) row,
emp_name, basic from emp_master)
select * from cte where row =2 or rank1 in ( select rank1
from cte group by rank1 having count(rank1)=1)

there i am used the MS SQL Server 2005.

Answer / chaitanya pathak

select max(salary) from employee
where salary<(select max(salary) from employee)

Answer / bharath reddy

These qeries give you second higest salary

select e.sal from emp e,emp d where d.sal>e.sal
group by e.sal
having count(e.sal)=2
;

SAL
-----
3000

(or)

select distinct e.sal from emp e where (select count(sal)
from emp d where d.sal>e.sal)=1;

SAL
-----
3000

Answer / teja

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

Answer / anandaraj

This below query is used to get the name and salary of
second highest salary person. Its work great.

select Name, Salary from table_3 where salary = (select max
(salary) from table_3 where salary < (select max(salary)
from table_3 )).

Answer / raju

select top 1 sal from emp
where sal not in (select top 1 sal from emp order by sal
desc ) order by sal desc

Answer / jigar r gor

Select sal from emp where sal < (select max(sal)from emp)
and rownum < 2 order by sal desc

Answer / sagar padekar

select * from bill_gen
where total_payable< (select max(total_payable) from
bill_gen) order by total_payable desc limit 1;

hey please refer total_payable as salary amount

Answer / shiva

select salary from table_name where salary <(select salary
from table_name);

Answer / yash goyal

Select slary from
(select salary from empolyees
order by salary desc
where rownum<=&no.)
order by salary Asc
where rownum=1;

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

how to create a database in oracle?please gve anser with example

1 Answers  

What is the difference between pl and sql?

0 Answers  

Which join is default?

0 Answers  

What is pl sql quora?

0 Answers  

Which is the best place to learn hadoop?

1 Answers  

how many tupples can insert in 1 second in sql

1 Answers  

What are triggers, and when would you use them?

3 Answers  

What are triggers and its uses?

0 Answers  

What is pl/sql language case sensitive?

0 Answers  

what are numeric data types? : Sql dba

0 Answers