Hi, I have a problem about writing a proper SELECT query for the following goal: (I only have basic knowledge of SQL)
Table name: peoplelist column 1: id (not NULL, auto_incremental) column 2: name column 3: country now, there are about 7,000 rows in this table. I want to select out: first (in terms of id) 10 or less people of each country. There are more than 100 countries. One solution is to run one query for each country, then combine the results. But how can I do this in a better way, e.g. by one SELECT sql query ? ps. I am using MySQL 4.0 that doesn't support subselect. Thanks. Han ===== Email: [EMAIL PROTECTED] __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]