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;

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

What is dialect in sql?

0 Answers  

what is check constraint? : Sql dba

1 Answers  

What is sorting in sql?

0 Answers  

What is character functions?

0 Answers  

What is the differnce between view and materialized view

4 Answers   TCS,

What are types of joins?

0 Answers  

What is the difference between having clause and where clause?

0 Answers  

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

How many subqueries can be nested in a statement?

0 Answers  

How do you delete a table?

0 Answers  

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers