List:General Discussion« Previous MessageNext Message »
From:Hank Date:September 29 2005 4:48pm
Subject:Re: Limiting "DISTINCT" To One Column
View as plain text  
To check for more than one channel-per-record in the table:

select channel,count(*) as cnt from ChannelStatus group by channel having cnt>1

should return zero records if you have no dups.

On 9/29/05, Hal Vaughan <hal@stripped> wrote:
> I have a query like this:
> SELECT DISTINCT Channel, ChannelType, Source FROM ChannelStatus;
> Each channel is supposedly listed in this table only 1 time, but just in case,
> what I really want to do is make sure that no channels are duplicated.  Is
> there some way to make the keyword "DISTINCT" apply to Channel only?  Sort of
> a shortcut to (example in pseudocode, although it'd be in Perl):
> SELECT DISTINCT Channel FROM ChannelStatus;
> FOR EACH Channel
>        SELECT Channel, ChannelType FROM Source WHERE Channel = 'channel'
> Thanks!
> Hal
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:


Limiting "DISTINCT" To One ColumnHal Vaughan29 Sep
  • Re: Limiting "DISTINCT" To One ColumnHank29 Sep