AW: Query problem

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 Nachricht- Von: Dan Buettner [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. August 2006 20:15 An: André Hänsel Cc:

Re: AW: Query problem

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 Nachricht-

AW: Query problem

-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 (time, username, download). Now

Re: AW: Query problem

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 (time, username,

AW: query problem

Hi Jon, you can : DELETE FROM db_test.tbl_dbaddr; This would delete all data in db_test.tbl_dbaddr by first dropping the whole table and then rebuild it again. You can of curse add a 'WHERE CLAUSE' to determin which rows shall be deleted. This is from the HTML-manual: Duplicates indicates