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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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-2017 The PostgreSQL Global Development Group