select Distinct Top 2 Salary from EMP order by Salary desc

select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)

select ename,sal from emp E where 1=(select count(*) from
emp where E.sal<sal)

select top 2 salary from emp order by salary desc

or if u want 2nd highest then write this query

select Top 1 salary from ( select top 2 salary from 
emp_table order by salary desc)temptable order by salary 
asc.

select max(salary) as salary1 from employee where salary < 
select max(salary) as salary2 from employee

select * from emp e where 2>=(select count(distinct esal) 
from  emp where e.esal<=esal)

select Top 1 salary from ( select top 2 salary from 
emp_table order by salary desc)temptable order by salary 
desc.

select Top 1 salary from ( select top 2 salary from 
emp_table order by salary desc)temptable order by salary 
asc.

select Distinct Top 2 Salary from EMP order by Salary desc

select * from emp e where 2>(select count(esal) from emp 
where e.esal<=esal)

select * from Emp e where 1=(select count(Distinct
d.esal)from emp d where d.esal>e.esal)

i am sure that it should work.


Any thing wrong plz inform me

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM 
employee ORDER BY salary DESC) a ORDER BY salary

Find The 4 Top Salary in a Company
----------------------------------

CREATE TABLE EMPLOYEE2 (NAME VARCHAR2(20), SALARY NUMBER) ;

CREATE TABLE employee2 (
	name char(20),
	salary float);
INSERT INTO employee2 VALUES (
	'Raja',
	10000);
INSERT INTO employee2 VALUES (
	'Arithas',
	10000);
INSERT INTO employee2 VALUES (
	'Balaji',
	12000);
INSERT INTO employee2 VALUES (
	'Vairam',
	13000);
INSERT INTO employee2 VALUES (
	'Muthu Krishnan',
	14000);
INSERT INTO employee2 VALUES (
	'Muthu Kumar',
	15000);
INSERT INTO employee2 VALUES (
	'Ramesh',
	9000);

select e.name,e.salary from Employee2 e where 4>(select 
count(Distinct
d.salary)from employee2 d where d.salary>e.salary) order by 
e.salary desc;

select * from emp e where 2=(select count(sal) from emp
where e.sal<=sal)

select max(salary)from emp where salary <(select sum(salary)
from emp)

select * from tbl_htl_cntry e where 2>=(select
count(distinct salary) from  tbl_htl_cntry where
e.salary<=salary)

it is aslo working syntax.
ranjeetvasu@rediffmail.com

select ename,sal from emp where rownum<=3 order by sal desc

Note:- every table has rownum column but it is hidden by 
default you can see it by this
select rownum from your_table_name

select distinct top 2 salary from employee order by salary 
desc

select * from 
(select ID,Salary from employee order by Salary desc)
where rownum < 3

select * from(select * from Employee order by salary desc) where rowNum<3

Step1: 
Create the "Salary" table,

Create table Salary
( Design_name varchar(20),
  Basic_Sal int)

Step2:
Insert the values into "Salary" table,

Insert into Salary values('Office_Boy',4000)
Go
Insert into Salary values('Clerk',5000)
Go
Insert into Salary values('Head_Clerk',6000)
Go
Insert into Salary values('Accountant',7000)
Go
Insert into Salary values('Manager',8000)
Go
Insert into Salary values('PA',9000)
Go
Insert into Salary values('GM',10000)

Step3:
Write the Query aganist "Salary" table to find 'N'th 
Maximum Basic Salary.

Query:

Select * from Salary s1 where (N =(select count(distinct
(s2.Basic_Sal)) from Salary s2 
where s2.Basic_Sal>=s1.Basic_Sal))

N=1 --> Finds the first maximum Basic_sal
N=2 --> Finds the second maximum Basic_sal
N=3 --> Finds the Third maximum Basic_sal
.
.
.
N='N'--> Finds the 'N'th maximum Basic_sal 

To find '2' maximum:

Select * from Salary s1 where (2=(select count(distinct
(s2.Basic_Sal)) from Salary s2 
where s2.Basic_Sal>=s1.Basic_Sal))

Output:

Design_name   Basic_sal

PA	       9000

select max(sal) from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));