Hi Peter, select count(*), record_id from mytable group by record_id having count(*)>1
David Cummins Peter Tilbrook wrote: > > I need to find out if a certain record ID occurs more than once. > > What SQL code should I use to count the ID field if it occurs more than once > (and output the occurrences)? > > Thanks :) > > == > Peter Tilbrook ([EMAIL PROTECTED]) > Macromedia ColdFusion Applications Developer > Cubok Pty. Ltd. > Units 7-10 > Australian Heritage Village > Watson ACT 2602 > AUSTRALIA > > http://www.cubok.com > > Mobile: 0401 973 415 > Tel: +61-2-6262-4080 > Fax: +61-2-6262-4081 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
