Re: Third largest salary

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/11/04 

Date: Tue, 11 May 2004 20:47:54 +0530

try query as shown in following example:

create table test (id int)

insert into test values (1033)
insert into test values (2093)
insert into test values (2323)
insert into test values (2323)
insert into test values (45534)

--query
 select *
  from test a
  where
  (select count(distinct id) from test b where b.id <= a.id) = 3 

--
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com