X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6A053D1B563 for ; Mon, 22 Sep 2003 05:22:54 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 50395-07 for ; Mon, 22 Sep 2003 02:22:24 -0300 (ADT) Received: from hotmail.com (law12-oe66.law12.hotmail.com [64.4.18.201]) by svr1.postgresql.org (Postfix) with ESMTP id F2947D1B4FE for ; Mon, 22 Sep 2003 02:22:22 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 21 Sep 2003 22:22:23 -0700 Received: from 203.199.110.6 by law12-oe66.adinternal.hotmail.com with DAV; Mon, 22 Sep 2003 05:22:22 +0000 X-Originating-IP: [203.199.110.6] X-Originating-Email: [naveen_shanbhag@hotmail.com] From: "NAGAPPA" To: References: <20030920170512.76693.qmail@web60107.mail.yahoo.com> Subject: selecting duplicate records Date: Mon, 22 Sep 2003 11:07:10 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01C380F9.AAFD87E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: X-OriginalArrivalTime: 22 Sep 2003 05:22:23.0066 (UTC) FILETIME=[8096E3A0:01C380C9] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=HTML_50_60, HTML_FONT_FACE_ODD, REFERENCES X-Spam-Level: X-Archive-Number: 200309/242 X-Sequence-Number: 15220 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C380F9.AAFD87E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I would like to know the following 1. How to select duplicate records only from a single table using a select = query. Thanks in advance Regards naveen ----- Original Message -----=20 From: yogesh selukar=20 To: pgsql-sql@postgresql.org ; sandis@mediaparks.lv=20 Sent: Saturday, September 20, 2003 10:35 PM Subject: Re: [SQL] Simple concatenation in select query Hello Everybpdy, The concatination in select query u can write the query like this. select c.status||' this '||' is '||' the '||' status ' from course_maste= r as c; This works fine Regards Yogesh ---------------------------------------------------------------------------= --- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software ------=_NextPart_000_000E_01C380F9.AAFD87E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I would like to know the=20 following

1. How to select duplicate r= ecords=20 only from a single table using a select query.

Thanks in advance

Regards

naveen

----- Original Message -----

Fro= m:=20 yogesh selukar

To: pgsql-sql@postgresql.org ; <= A=20 title=3Dsandis@mediaparks.lv=20 href=3D"mailto:sandis@mediaparks.lv">sandis@mediaparks.lv

Sent: Saturday, September 20, 2003= 10:35=20 PM

Subject: Re: [SQL] Simple concaten= ation=20 in select query

Hello Everybpdy,

The concatination in select query u can wri= te=20 the query like this.

select c.status||' this '||' is '||' the '||' status '= from=20 course_master as c;

This works fine

Regards

Yogesh

Do you Yahoo!?
Yahoo!=20 SiteBuilder - Free, easy-to-use web site design=20 software ------=_NextPart_000_000E_01C380F9.AAFD87E0--