Re: TOP 100 in SQL
Basic idea came from a book by Joe Celko, "SQL For Smarties".
rfurdzik@paulweiss.com wrote:
> This algorithm is really great, did you find it by yourself ? If yes, you=20=
> are=20
> very good in SQL language=2E
> How did you do it ?
> =20
>
> Douglas Agnew <dagnew@bellsouth=2Enet> on 11/12/98 11:38:15 AM
> Please respond to Douglas Agnew <dagnew@bellsouth=2Enet>
> To: informix-list@iiug=2Eorg
> cc: (bcc: Rafal Furdzik/PaulWeiss)
> Subject: Re: TOP 100 in SQL
>
> without the first 100 capability:
> 1=2E create a view x (a, total) as
> select a, sum(b) from c
> group by a;> 2=2E then select a, total from x t1
> where (select count(a) from x t2 where t2=2Etotal >
> t1=2Etotal) < 100
> It works --- but it is expensive=2E better to write application=2E
>
> Doug Agnew (dagnew@charlottepipe=2Ecom)
>
> rfurdzik@paulweiss=2Ecom wrote:
>
> > How to display only first 100 rows from a query ??? Please help
> >
> > Select a, sum(b)
> > group by a DESC> >
> > __________________________________________________
> >
> > This message is intended only for the use of the=3D20
> > Addressee and may contain information that is=3D20
> > PRIVILEGED and CONFIDENTIAL=3D2E If you are not the
> > intended recipient, you are hereby notified that
> > any dissemination of this communication is
> > strictly prohibited=3D2E If you have received this
> > communication in error, please erase all copies of
> > the message and its attachments and notify us
> > immediately=3D2E Thank You=3D2E
> > __________________________________________________
>
> __________________________________________________
>
> This message is intended only for the use of the=20
> Addressee and may contain information that is=20
> PRIVILEGED and CONFIDENTIAL=2E If you are not the
> intended recipient, you are hereby notified that
> any dissemination of this communication is
> strictly prohibited=2E If you have received this
> communication in error, please erase all copies of
> the message and its attachments and notify us
> immediately=2E Thank You=2E
> __________________________________________________