Re: Top N selections + rest row

[Barry]

C.R.Vegelin wrote:
> Hi All,
> 
> Anybody with smart ideas to get Top-N rows plus the rest row ?
> Suppose I have ranked sales values descending for 2005, like:
> Select Country, Sum(Sales) AS Sales From myTable
> Where Year=2005 Group By Country 
> Order By Sales DESC LIMIT 25;
> 
> Then I get Top-25 sales rows, but I also want a rest row,
> where all 26 rows represent the world total.
> I'm using MySQL 5.0.15.
> 
> Regards, Cor
> 
Writing it into a cache_table.
Write the first rows into the cache_table and then the rest of it.
-- 
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)