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 70B9DB4276B for ; Mon, 7 Jul 2003 08:46:35 +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 79033-10 for ; Mon, 7 Jul 2003 05:46:03 -0300 (ADT) Received: from mx01 (mx01.edu-x.com [202.190.118.122]) by svr1.postgresql.org (Postfix) with ESMTP id 42DA7B42167 for ; Mon, 7 Jul 2003 05:46:02 -0300 (ADT) Received: from mx01 ([127.0.0.1]) by mx01 with Microsoft SMTPSVC(5.0.2195.5329); Mon, 7 Jul 2003 16:31:21 +0800 Received: by mail.umm.com.my id h671Nh119524; Mon, 7 Jul 2003 09:23:43 +0800 (SGT) Date: Mon, 7 Jul 2003 09:23:43 +0800 (SGT) Message-Id: <200307070123.h671Nh119524@mail.umm.com.my> X-Originating-IP: [192.228.137.71] X-Mailer: Fastmail 2.1 (Web based email system) Subject: Merge Record in Database(SQL Statement) From: Shahbuddin Md Isa To: pgsql-sql@postgresql.org X-OriginalArrivalTime: 07 Jul 2003 08:31:21.0218 (UTC) FILETIME=[24D8D620:01C34462] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/56 X-Sequence-Number: 14170 Hai.. How to merge record in database(sql statement) if record same attribute, examples:- Attribute Major Birth_Place GPA Record 1 science India excellent Record 2 science India excellent Please help me.. ____________________________________________________________ Powered by Fastmail from http://www.i-fastmail.com