Re: Get the same value only once

Try

create table foo as
select distinct town, zip_code
from table1;

Mark

In article <3833bc38.83931126_at_news.ratiokontakt .de>, markus.spindler_at_gmx.de (Markus Spindler) wrote:
> Hallo
> I have a table with about 170000 addresses of customers. Now I
> want to
> make a master table with the zip codes and town.
> Is the any SQL function that gives the same value (for example
> Munich)
> only once, to insert it in the new master table?
> Any help would be great!
> Markus Spindler

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!