So depending on which columns you were looking at, two rows might seem like
duplicates or not? If your SELECT statement only requested certain fields,
your result set might have duplicates that wouldn't be duplicates if you
were looking at other columns as well? Is this correct?
So if I had this in a table:
pet name age
------------------------
dog Spot 5
dog Fluffy 5
cat Clara 3
and I did
SELECT DISTINCT pet, age
I'd get back just two rows.
If I did this:
SELECT DISTINCT *
I'd get back all three rows.
Am I understanding this correctly?
- Sheryl
mysql
----- Original Message -----
From: "Juan Nin" <[EMAIL PROTECTED]>
To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 2:42 PM
Subject: Re: SELECT DISTINCT question
From: "Sheryl Canter" <[EMAIL PROTECTED]>
> > 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?
in the SELECT statement :)
SELECTs do not alter your rows, you can only do that with update or delete
regards,
Juan
---------------------------------------------------------------------
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
