Answer / arrry.net

SELECT * FROM employee
WHERE Salary=(SELECT max(Salary)
FROM employee WHERE Marks< (SELECT max(Salary) FROM
employee));

Answer / arrry.net

Select top 1 salary from tbl_registration where salary in
(SELECT TOP 2 salary from tbl_registration)
order by salary desc

Answer / vishnu

Here we can find out 2nd highest salary in many ways,
according to the situation we can select anyone…
1st Type:
select min(esal) from emp where esal in (select top 2 esal
from emp order by esal desc)

2nd Type:
select max(esal) from emp where esal not in(select max(esal)
from emp)

3rd Type:
select max(esal) from emp where esal <(select max(esal) from
emp )

4th Type:
select Max(esal) from EMP a where 2=(select
COUNT(distinct(esal)) from EMP b where a.eSAL<=b.eSAL);

-----------------------------------------

For 2nd Lowest Salary:

-- 1st Type:
select min(esal) from emp where esal > (select min(esal)
from emp)

-- 2nd Type:
select * from emp where esal =
(
select max(esal) from emp where esal in (select top 2 esal
from emp order by esal)
)

Answer / sudhir

1. 2nd highest salary=>

Select top 1 * from (select top 2 * from emo order by sal
desc) order by sal asc

2. 2nd lowest salary

Select top 1 * from (select top 2 * from emo order by sal
Asc) order by sal Desc

Answer / sathish

select max(Salary)from employee where Salary not in (select
max(Salary)from employee )



select min(Salary)from employee where Salary not in (select
min(Salary)from employee )

Answer / mohsin mukri

select max(salary) as Salary from tbl_Employee
where salary < (select max(salary) from tbl_employee)


sory above post ans is wrong bcoz i forgot to remove = sign

Answer / mohsin mukri

select max(salary) as Salary from tbl_Employee
where salary <= (select max(salary) from tbl_employee)

Answer / pankaj kumar

if am not wrong we can also do the same thing by using aggreate function like Min or Max..

Like if i want to know 4th Highest Salary then i can

SELECT MIN(Sal) FROM TableName
WHERE Sal IN
(SELECT TOP 4 Sal FROM TableName ORDER BY Sal DESC)

Regards
Pankaj Kumar
pankaj.arrah@gmail.com

Answer / deepak

select max(amt)as amt from EmployeePaymentDetails where amt<
(select max(amt)as amt from EmployeePaymentDetails)

Answer / prasoon madnawat

i forgot order by in da last post
SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE order
by Salery DESC)

Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM
<3 order by Salery DESC)

MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE order by
Salery DESC LIMIT 2)

likewise for 2nd minimum salery.

How cache coherency is eliminated? : Dot net architecture

0 Answers  

Explain the process of gc?

0 Answers  

What is the cli? Is it the same as the clr?

0 Answers  

how to make and display a form without title bar?

0 Answers   Six Sigma,

Explain about microsoft visual studio?

0 Answers  

Explain difference between machine config vs. Web config : Dot net architecture

0 Answers  

What is a virtual memory? : Dot net architecture

0 Answers  

Write a query Where,Groupby,having clauses?

2 Answers   iGate,

What is textbox control of .net mobile? : Microsoft dot net mobile

0 Answers  

what is the use of SQL command builder class in C#.net? Explain how can we execute a stored procedure using C#.Net? What is the difference between .DLL and .EXE?

2 Answers  

i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?

0 Answers  

How do you handle this COM components developed in other programming languages in .NET?

0 Answers   InfoAxon Technologies,