So sprach »John Hunter« am 2001-07-17 um 14:42:13 -0500 :
>
> I have a table in which I want to eliminate duplicates, where I define
> a duplicate to be any two rows with the same values on field1 and
> field2
>
> This gives me the sort I want
> SELECT * FROM this_table ORDER BY name, time;
Untested:
SELECT * FROM this_table ORDER BY name, time GROUP BY CONCAT(field1,
field2);
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 13 hours 28 minutes
---------------------------------------------------------------------
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