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.

Session State and can i store desirialized object in state server, if yes how and if not why.

0 Answers   PCS,

What is parallel computing?

0 Answers  

Difference between abstract class and interface

100 Answers   Accenture, Altruist, Baba Group, CitiGroup, Fiserv, HCL, IBM, iGate, Infosys, Jean Martin, Karthik Industries, Microsoft, OnDLine, TCS,

How to prevent my .NET DLL to be decompiled?

0 Answers   CDC,

What is the purpose of Accordian in jquery? Where it can be used?

0 Answers  

Explain hard disk and what is its purpose? : .NET Architecture

0 Answers  

What is a managed code? : Dot net architecture

0 Answers  

what is the method while we are using adapter and dataset ?

0 Answers  

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

0 Answers  

What is IL code, CLR, CTS, GAC & GC?

0 Answers   MindCracker,

IS IT Possible to inherit the AJAX page from child class which(child) is inherit from page class.Because i should apply some security in child class

0 Answers   IBM,

Can I create my own context attributes?

0 Answers