Re: TOP 100 in SQL
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