[thelist] Simple table question...

Matt Warden mwarden at gmail.com
Mon May 9 18:31:11 CDT 2005


On 5/9/05, Jonathan Dillon <jdillon at boehm-ritter.com> wrote:
> SELECT DISTINCT(email), firstname, lastname, phone FROM tablename;
> 
> This is rather retarded, but why would this pull up duplicate emails?  I
> just don't understand.  I thought DISTINCT would explicitly be distinct to
> the column name.

What is it to do with the following data?

joe at blow.com Joe Blow 555-555-5555
joe at blow.com Joe Blow 555-555-5556

What row is it supposed to return?

The reality is that every unique *combination* of fields listed after
the DISTINCT keyword will be returned.

-- 
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.


More information about the thelist mailing list