Basic SQL

• Jlow

  SSC Rookie

  Points: 29

  More actions

  May 4, 2004 at 5:26 am

  #161908

  Hi,

   

  I'm new to writing sql scripts and need a little help.  I have a table which contains client data.  Some clients have only 1 entry, some have multiples.  Table is keyed on clientID.  How do I get a list of the clients with multiple entries only ?

   

  Thanks,

  Jane

• wz700

  SSCertifiable

  Points: 7133

  More actions

  May 4, 2004 at 5:44 am

  #505110

  select clientID, count(*) from table

  group by clientID

  having count(*) > 1

• angel-117050

  Mr or Mrs. 500

  Points: 597

  More actions

  May 5, 2004 at 11:40 am

  #505349

  As a general rule, table key should be unique. You may want to consider two tables instead of one. One for Client, the other for Client Data.