> 1. How to select duplicate records only from a single table using a select > query. > e.g. select sid,count(sid) from location group by sid having count(sid)>1;
Do you get the idea? Your request is pretty unspecific, so if this is not what you're asking for, try again. Regards, Christoph ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]