Postgres Pro
Downloads
Home   >   mailing lists

selecting duplicate records - Mailing list pgsql-sql

From NAGAPPA
Subject selecting duplicate records
Date
Msg-id OE66rufdDh08nt9fDUy000026b3@hotmail.com
Whole thread Raw
In response to Re: Simple concatenation in select query  (yogesh selukar <yogesh_selukar@yahoo.com>)
List pgsql-sql
Tree view
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 -----
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_master as c;
         This works fine
 
Regards
 
Yogesh

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

pgsql-sql by date:

Previous
From: sad
Date:
Subject: Re: Reg: Firing Trigger when a particular column value get changed
Next
From: "Kumar"
Date:
Subject: Backup error - Pls help