Re: select distinct

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 28 Aug 1999 12:20:09 GMT
Message-ID: <01bef14f$a26522c0$505b95c1@default>

Why do you have multiple names for a given customerno?? Doesn't look right to me.

cheers

Glenn Baron

Mark Foley <foleym_at_meftechno.com> wrote in article <7q7btd$d5r_at_chronicle.concentric.net>...
> I have a table with the following columns
>
> customerno name
> 1234 John
> 1234 Bill
> 1235 Jan
> 1236 Mark
>
>
> What I want for a result set is:
> 1234 John
> 1235 Jan
> 1236 Mark
>
>
> If I use "select distinct customerno,name from table"
> I still get all of the rows.
>
> "select distinct customerno from table" gets the unique customer
numbers,
> but not the names.
>
> I have to believe there is a sql statement that will accomplish this...
> Can anyone help?
>
>
>
>
Received on Sat Aug 28 1999 - 07:20:09 CDT