Path: utzoo!attcan!uunet!samsung!zaphod.mps.ohio-state.edu!mips!apple!agate!ucbvax!hplabs!hpfcso!hpldola!tn
From: tn@hpldola.HP.COM (Ted Neff)
Newsgroups: comp.databases
Subject: Re: SQL query for duplicates
Message-ID: <11650002@hpldola.HP.COM>
Date: 23 Dec 89 02:12:48 GMT
References: <5784@uhccux.uhcc.hawaii.edu>
Organization: HP Elec. Design Div. -ColoSpgs
Lines: 6

How about the following:

	SELECT fieldname
	FROM tablename
	GROUP BY fieldname
	HAVING COUNT(*) > 1