|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: SELECT DISTINCT doesn't work
From: Sven Köhler (skoehler
upb.de)
Date: Mon May 31 2004 - 06:01:49 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]