SELECT DISTINCT ROW(A,B) from a;
While I am on a roll (of sorts) can I ask if the above syntax should be valid or not?
If you mean the exact syntax above, I think not... it looks like ROW() is a function taking two parameters in this case... what does the function return? Is it an aggregate function?
If the ROW() function was a synonym for the CONCAT() function, or worked in a similar way, it might work, but what is the point?
I have a feeling it should be valid (but isn't - it causes an error).
Is this the correct behaviour?
Try this:
SELECT DISTINCTROW A,B from a;
DISTINCTROW and DISTINCT are synonyms:
<URL: http://dev.mysql.com/doc/mysql/en/select.html#id2828077 >
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]