Skip site navigation (1) Skip section navigation (2)

Re: eliminating duplicates in results..

From: Jesus Aneiros <aneiros(at)jagua(dot)cfg(dot)sld(dot)cu>
To: Francisco Hernandez <xy0xy0(at)earthlink(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: eliminating duplicates in results..
Date: 2000-06-22 14:53:36
Message-ID: Pine.LNX.4.10.10006221053270.7385-100000@jagua.cfg.sld.cu (view raw or flat)
Thread:
Lists: pgsql-sql
SELECT DISTINCT

On Wed, 21 Jun 2000, Francisco Hernandez wrote:

> hello everyone,
> i have a query like so:
> 
> select item.type as ig_id,item.with_design,item_group.type as
> group_name, 'true' as valid from item,item_group where item.description
> ~* 'w/out' and item.type = item_group.ig_id;
> 
> and i get duplicates.. how could i remove all the duplicate entrys using
> SQL?
> the duplicates are fine.. im just trying to migrate data from one table
> to another.. with columns renamed and some added/removed..
> 


In response to

pgsql-sql by date

Next:From: Web ManagerDate: 2000-06-22 19:52:59
Subject: Wildcard in date field???
Previous:From: Francisco HernandezDate: 2000-06-21 23:53:41
Subject: eliminating duplicates in results..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group