SQL

From: Brian Vuong <brian-vuong_at_usa.net>
Date: 2000/06/23
Message-ID: <sl80dq8je7f124@corp.supernews.com>#1/1

Could someone help me with this. I have two fields, acctno ( account number) and ssn. I would like to write a query to obtain only the customers that have more than one account. To determine if someone has more than one account by checking for duplicate ssn. Both ssn and acctno are character fields. I spent two days to try to figure out, but I could not do it. There is only 1 table

select acctno, name, ssn
from table1

where count(ssn)>1;   <----------------this does not work.

Sincerely,

Brian Received on Fri Jun 23 2000 - 00:00:00 CDT