[SQL] selecting duplicate records

[NAGAPPA]

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: [EMAIL PROTECTED] ; [EMAIL PROTECTED] 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