Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
Re: SELECT DISTINCT doesn't work
From: Sven Köhler (skoehlerupb.de)
Date: Mon May 31 2004 - 06:01:49 CDT
> You might want to check that you don't have any tuples that are
> otherwise identical apart from NULLs versus empty strings in a character
> field - DISTINCT treats these rows as, well, distinct :-).
i think he shouldn't include the record_id, since it might be a
serial-column and therefor differs for each record.
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb