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;

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

What are dml commands?

0 Answers  

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

What is number function in sql?

0 Answers  

What do you mean by “trigger” in sql?

0 Answers  

cursor types? explain with example programs?

1 Answers   HP,

What is thread join () in threading?

0 Answers  

what tools available for managing mysql server? : Sql dba

0 Answers  

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

what is the command for user data type?

2 Answers  

What are the two different parts of the pl/sql packages?

0 Answers