Re: AW: Query problem

2006-08-03 Thread John Meyer
André Hänsel wrote: >> -Ursprüngliche Nachricht- >> Von: Miles Thompson [mailto:[EMAIL PROTECTED] >> Gesendet: Donnerstag, 3. August 2006 21:56 >> An: mysql@lists.mysql.com >> Betreff: Re: Query problem >> >> At 03:08 PM 8/3/2006, André Hänsel wrote: >> >>> I have a table logging downloads

Re: AW: Query problem

2006-08-03 Thread John Meyer
SELECT DISTINCT username, time, download FROM table ORDER BY time DESC GROUP BY username André Hänsel wrote: > Hi Dan, hi Obed, > > of course I have no specific username, I want the last 5 downloads of each > distinct username in the table. :) > > Regards, > André > >> -Ursprüngliche Nachr