Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Complex MySQL query


VuoriLiikaluoma - 10:49 am on Dec 28, 2010 (gmt 0)


You should check out MySQL MIN() aggregate function and GROUP BY.

for ex: SELECT a, MIN(b) FROM c GROUP BY d;

Hope that helps somewhat...


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