Re: Find a duplicate value via SQL

On 15 Sep 98, at 17:01, Tim_Clifton@candle.com wrote: > This is undoubtedly a pedestrian question to some of you, but as I am > new to SQL...... Does anyone know of a quick way to find records that > contain duplicate values for a particular field via SQL? Or is this done > is SPL? TIA SELECT colname, COUNT(*) FROM tabname GROUP BY colname HAVING COUNT(*) > 1 Ish. -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________