Paul,
> DISTINCT removes duplicates: rows that are the same in *all* columns.
Would this be all columns in the table, or all columns retrieved by the
SELECT statement?
TIA.
- Sheryl
sql,query,queries,smallint
----- Original Message -----
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
"Frank Peavy" <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 12:34 PM
Subject: Re: SELECT DISTINCT question
At 11:50 -0500 2/28/03, Sheryl Canter wrote:
>Frank,
>
>Sorry that I seem to be explaining this so poorly. I'll try to clarify what
>I'm trying to do and what my questions are. Someone on this list did give
me
>code that I think will work. I haven't had a chance to try it yet.
>
>My question about how DISTINCT works is this: does it operate on the
*result
>set*? So depending on my SELECT statement and which fields I bring in,
>different rows may be distinct? It's my guess that it works this way. I
want
>to confirm.
DISTINCT removes duplicates: rows that are the same in *all* columns.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
