Manish Marathe wrote:
SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC;
DISTINCT is not a function. The above (if it even works) is exactly
equivalent to:
SELECT DISTINCT name, date, value FROM table_name ORDER BY date DESC;
and will match distinct rows (that is, combinations of name, date and
value).
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
