Who knows how to delete duplicate values in a column via SQL. Some of the
goofy data I ported over from an MS Access "database"

Has duplicate values in a Code/Description table (different codes, same
descriptions). I want to leave just one record for each distinct
description. IOW, instead of



CODE DESCRIPTION

01 TUBERCULOUS PLEURISY IN PRIMARY
PROGRESSIVE TUBERC

02 TUBERCULOUS PLEURISY IN PRIMARY
PROGRESSIVE TUBERC

10 TUBERCULOUS PLEURISY IN PRIMARY
PROGRESSIVE TUBERC

11 TUBERCULOUS PLEURISY IN PRIMARY
PROGRESSIVE TUBERC



I want to end up with just:

CODE DESCRIPTION

12 TUBERCULOUS PLEURISY IN PRIMARY
PROGRESSIVE TUBERC



Or so..





Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]