Answer / soorai ganesh

SELECT 'Second Highest Salary Is ', MAX(Salary) FROM Employee WHere Salary < ( Select MAX(Salary) FROM Employee )

SELECT 'Second Least Salary Is ',MIN(Salary) FROM Employee WHere Salary > ( Select MIN(Salary) FROM Employee )

Answer / mehul

for 2nd highest salary

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


for 2nd least salary

select min(salary) from employee where salary>(select min
(salary) from employee )

i hope that will help you

Answer / bobby

select p.emp_id,p.name,p.salary from
(select emp_id,name,salary,dense_rank()over( order by
salary desc)maxrank,
dense_rank()over( order by salary asc)minrank from test)p
where maxrank=2 or minrank=2

Answer / smitha

2nd Highest Salary

Select top 1 salary from (select distinct top 2 salary
from employee order by salary desc)a
order by salary

2nd Least Salary

Select top 1 salary from (select distinct top 2 salary
from employee order by salary asc)a
order by salary desc

Answer / sridhar sahoo

select distinct top 1 salary from payroll..emp where salary
in(select distinct top 3 salary from payroll..emp order by
salary desc)

Answer / prasanthi

Query for Getting 2nd least salary (replace 2 with any
number so that you will get any least salary:

select max(Salary) from Employee
where Salary in
(select distinct top 2 Salary from dbo.Employee order by
Salary asc)

Query for Getting 2nd Height salary (replace 2 with any
number so that you will get any least salary:

select min(Salary) from Employee
where Salary in
(select distinct top 2 Salary from dbo.Employee order by
Employee desc)

Answer / sridhar sahoo

select distinct top 1 salary from payroll..emp where salary
in(select distinct top N salary from payroll..emp order by
salary desc)

if u want top 2 put 2 at the pacece of N
if u want top 5 put 5 at the pacece of N
if u want ..............................

Answer / narayana

select top 1 sal from (
select top 2 sal from Emp order by sal desc) as a order by sal asc


select top 1 sal from(
select top 2 sal from Emp order by sal ) ss order by sal desc

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

How to drop an existing schema in ms sql server?

0 Answers  

Explain what is the difference between union and union all?

0 Answers  

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

Explain error and transaction handling in sql server?

0 Answers  

What is the cartesian product of table?

0 Answers  

How to write an inner join with the where clause in ms sql server?

0 Answers  

What is an index in sql?

0 Answers  

How secure is sql server database?

0 Answers  

When would you prefer to have a minimum number of indexes?

0 Answers  

Explain indexing and what are the advantages of it?

0 Answers  

Can a database be shrunk to 0 bytes, if not, why?

0 Answers