Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Select Distinct then Minimum.

LifeinAsia - 10:07 pm on Nov 22, 2010 (gmt 0)


Off the top of my head, I think this will work:
SELECT Table.*
FROM (SELECT Type, MIN(ID) AS ID FROM Table GROUP BY Type) AS a INNER JOIN Table ON a.ID=Table.id

Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4233813.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com