Re: Identifying duplicate rows

>select distinct number group by number having count(*)>1;

argh. you are using access, aren't you?

ciao, jan

http://www.rsp.de - Software zur effizienten Erstellung und Verwaltung von Gutachten, Analysen, Pruefprotokollen etc. Received on Thu Feb 03 2000 - 02:12:45 CST