Hi, I've got item table as follwoing: itemno |item_name 1 item one 2 item two 3 item three 4 item four 2 item two 3 item three
I want to right a query so I get three rows of each item I specify in WHERE for example SELECT itemname from item WHERE itemno IN (1,2,3); Results should return first three rows of each itemno How do I write such query? Thanx --------------------------------------------------------------------- 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