Marking second (and subsequent) duplicates

PROBLEM:
Data contains duplicate values on ACCOUNT_NO. Want to leave one copy in place and mark 2nd and any subsequent duplicates as errors.

Does anyone know a tricky way to do this besides writing a cursor loop to compare the values (how 3GL of me)?

• Ronald K. Olcott, President
• Interlude Enterprises Innovation and Excellence in Database Applications

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 28 1999 - 20:19:19 CST