On 18-Apr-01 Jason Caldwell wrote:
> Opps. I meant GROUP BY... and it looks like I don't need to include the
> COUNT().
>
> SELECT email_addr, x GROUP BY email_addr HAVING x = 1;
>
> Is this the only way to display a listing without duplicates, or is there a
> more efficient (faster) way? I don't want to DELETE the duplicates, just
> don't want dups to show up in my SELECT queries.
>
> Thanks.
> Jason
>
>
select distinct(email_addr) ...
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]