Friday, January 02, 2004 4:42 PM
Subject: select distinct from two columns
> Hello,
>
> The two columns of my table are name and city. I am trying to do a list
which contains only the different names. This can be done this by distinct
keyword. But all the same names which have different citie
select distinct(col1,col2) should work.. Group by most certainly will... Select
col1,col2 from table group by col1, col2.. Same thing
> Hello,
>
> The two columns of my table are name and city. I am trying to
> do a list which contains only the different names. This can
> be done this by disti
:) I have solved the problem.
Thanks.
[EMAIL PROTECTED] (Veysel Harun Sahin) wrote:
>Hello,
>
>The two columns of my table are name and city. I am trying to do a list which
>contains only the different names. This can be done this by distinct keyword. But all
>the same names which have differe
* Veysel Harun Sahin
> The two columns of my table are name and city. I am trying to do
> a list which contains only the different names. This can be done
> this by distinct keyword. But all the same names which have
> different cities also have to be included in my list. So I can
> not do this wit
Hello,
The two columns of my table are name and city. I am trying to do a list which contains
only the different names. This can be done this by distinct keyword. But all the same
names which have different cities also have to be included in my list. So I can not do
this with a distinct keyword