Re: TOP 100 in SQL
You can use
select first 100 a, sum(b)
from <table name>
group by a DESC;
-ramana
In article <72cd6c$78e$1@news.xmission.com>,
rfurdzik@paulweiss.com 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=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
> __________________________________________________
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own