Re: How to do this query?

From: Dennis Wetherell <Wetherellm#m_Dennis_G_at_msmail.aai.arco.com>
Date: 1995/04/19
Message-ID: <D7AGwA.KM4_at_news.arco.com>#1/1


One way of doing it would be

select distinct C , count(*) from A group by C having count(*) > 1;

Dennis Wetherell
Wetherell#m#_Dennis_G_at_msmail.aai.arco.com Received on Wed Apr 19 1995 - 00:00:00 CEST

Original text of this message