List:General Discussion« Previous MessageNext Message »
From:Van Date:May 19 1999 11:50am
Subject:Re: select DISTINCT blah, wibble, fnord
View as plain text  
James Tyson wrote:
> 
> select DISTINCT blah, wibble, fnord
> 
> Now, I was under the impression, from what I had read that distinct
> eliminated duplicates from just the column it's used on. However, one of
> my other columns is a unix timestamp (and thus is always different) and
> distinct seems to return all of them.
> 
> Am I wrong, or is MySQL wrong?
> 
> James Tyson         --          System Administrator - The Internet Group.
>                                                           It's all good^Hf
distinct works on all explicitly listed  columns in the distinct clause.
Van
-- 
=========================================================================
Linux rocks!!!   www.dedserius.com
=========================================================================
Thread
select DISTINCT blah, wibble, fnordJames Tyson19 May
  • Re: select DISTINCT blah, wibble, fnordVan19 May
  • Re: select DISTINCT blah, wibble, fnordJim Faucette19 May