Re: TOP 100 in SQL

Thanks=2E Unfortunately we have version 7=2E23, which gives me syntax error=2E= =2E Stefanie Vario <svario@speedlink=2Enet> on 11/12/98 01:22:26 AM Please respond to svario@speedlink=2Enet To: informix-list@iiug=2Eorg cc: (bcc: Rafal Furdzik/PaulWeiss) Subject: Re: TOP 100 in SQL rfurdzik@paulweiss=2Ecom wrote: > > How to display only first 100 rows from a query ??? Please help > > Select a, sum(b) > group by a DESC> If you're using version 7=2E30 you can use the "first n" clause in the select statement=2E Example: select first 100 a, sum(b) from xxx group by a desc Stefanie Vario ZenaComp Incorporated svario@zenacomp=2Ecom __________________________________________________ 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 __________________________________________________