Re: Find a duplicate value via SQL

Tim I use this kind of SQL: SELECT field1 [, field2, ...], COUNT(*) FROM table GROUP BY field1 [. field2, ...] WHERE COUNT(*) > 1; Here field1 [, field2,...] are fields which are part of a unique combination and table is the table which contains duplicate records. HTH Sujit ______________________________ Reply Separator _________________________________ Subject: Find a duplicate value via SQL Author: Tim_Clifton@candle.com at internet Date: 9/15/98 5:01 PM Hello, 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