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)?
SELECT download FROM table WHERE username='user' ORDER BY time DESC LIMIT 5; -- http://www.obed.org.mx ---> blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]