Hello list, I have a table in a database that has a field named 'artist'. There are multiple entries of the same artist/band. Example: deftones iggy pop kiss deftones glassjaw deftones kiss new found glory kiss There's 3 entries for deftones and 4 entries for kiss. What I need to do is select a maximum of 2 entries for each artist. I've tried a few different things, but nothing has given me what I need. Is there any way to do this? Thanks everyone, Tyler Longren --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
