X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 0CC95B430D9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  7 Jul 2003 05:21:34 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 97236-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  7 Jul 2003 02:21:23 -0300 (ADT)
Received: from saphir (dsl-082-082-094-159.arcor-ip.net [82.82.94.159])
	by svr1.postgresql.org (Postfix) with ESMTP id D3A23B42168
	for <pgsql-sql@postgresql.org>; Mon,  7 Jul 2003 02:21:22 -0300 (ADT)
Received: by saphir (Postfix, from userid 1000)
	id 1C25D1310A1; Mon,  7 Jul 2003 07:21:19 +0200 (CEST)
Subject: Re: Merge Record in database(sql statement)
From: Markus Bertheau <twanger@bluetwanger.de>
To: Shahbuddin Md Isa <shahi@unitar.edu.my>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <200307070255.h672tt116429@mail.umm.com.my>
References: <200307070255.h672tt116429@mail.umm.com.my>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Message-Id: <1057555278.2840.8.camel@saphir>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.0 
Date: 07 Jul 2003 07:21:19 +0200
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/55
X-Sequence-Number: 14169

=D0=92 =D0=9F=D0=BD=D0=B4, 07.07.2003, =D0=B2 04:55, Shahbuddin Md Isa =D0=
=BF=D0=B8=D1=88=D0=B5=D1=82:
> Hai..=20
>=20=20
>     How to merge same record in database (sql statement), examples:-=20
>=20=20
>        Major     Birth_Place   GPA=20
>        -----     -----------   -----=20
>=20=20
>        science   India        excellent=20
>        science   India        excellent=20

select distinct * from table;

--=20
Markus Bertheau.
Berlin, Berlin.
Germany.