Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

simple SQL

0 views
Skip to first unread message

Ice

unread,
May 8, 2002, 10:39:27 PM5/8/02
to
Hi,

2 tables. Trying to list in descending order the top 10 largest 'summed
sales' (ie. sum (s.total) TOTALS). I can output the the summed sales
totals, I cannot break it down to the top 10. What am I missing?

Thanks
Tim
NCSU...@nc.wavetel.com


News Poster

unread,
May 28, 2002, 8:04:19 PM5/28/02
to
try

select top 10 sum(sales) from table order by sales desc

"Ice" <icema...@yahoo.com> wrote in message
news:zjlC8.106423$q8.10...@bin3.nnrp.aus1.giganews.com...

0 new messages