Re: TOP 100 in SQL - difference between Online and IUS

>If you're using version 7.30 you can use the "first n" clause in the >select statement. Example: > select first 100 a, sum(b) > from xxx > group by a desc The interesting part is (to me) the "first 100" bit, and the posters note that this is part of the 7.30 product, which I assume is the Online database - right. The "first N" does not work in my version of Universal Server, which I thought was identical to Online, with the extended data capabilities. Can somebody comment on this please. ============================================================ Roger S. Reynolds email: rsr@rogerware.com rsr@softix.com Web: http://www.rogerware.com Stefanie Vario wrote in message <364A7EA2.16DA@speedlink.net>... >rfurdzik@paulweiss.com 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.30 you can use the "first n" clause in the >select statement. Example: > select first 100 a, sum(b) > from xxx > group by a desc> >Stefanie Vario >ZenaComp Incorporated >svario@zenacomp.com