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: mysql@lists.mysql.com > Betreff: Re: Query problem > > For a specific username: > > SELECT username, time, download > FROM table > WHERE username = 'someusername' > ORDER BY time DESC > LIMIT 5 > > Dan > > On 8/3/06, André Hänsel <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have a table logging downloads (time, username, download). > > > > Now I'd like to have the last 5 downloads per user. > > > > Can someone tell me a solution (or what to search for)? > > > > Regards, > > André > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]