Re: SELECT DISTINCT

[Nuno Pereira]

Scott Noyes wrote:
Here's one (not very clean, but it works) way to do it:
SELECT id, params FROM table GROUP BY params;

The trouble is, how do you know which id should come with it?  If you table is

id  param
1   1
2   1

should the query return
1, 1
or 
2, 1
?

This is not really what I want, the reply from Shawn Green is just what 
I want.

--
Nuno Pereira

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]