Hi,
try to use "group by" clause in your select, e.g.
select name, city from mytable group by name, city order by name, city;
Best regards,
Mikhail.
- Original Message -
From: "Veysel Harun Sahin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 02, 2004 4:42 PM
Subje
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
