Re: Third largest salary

From: MUSTAFA (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Tue, 11 May 2004 23:55:44 -0700

THANKS VISHAL FINALLY ITS WORK!
MUSTAFA
>-----Original Message-----
>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
>
>
>
>.
>