selecting duplicate records

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 -----
From: yogesh selukar
To: pgsql-sql(at)postgresql(dot)org ; sandis(at)mediaparks(dot)lv
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