Non unique entries

Results 1 to 2 of 2

Thread: Non unique entries

  1. #1
    Join Date
    Dec 1969

    Default Non unique entries

    I am trying to write a SQL statement that will give me a complete listing of all records that have duplicate contract numbers.<BR><BR>I have a field called contractNumber and I wish to have the report list by contractNumber. I can get this report with the use of ASP, but would prefer a single SQL statement.<BR>Can someone help.<BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Non unique entries

    select contractNumber <BR> from t<BR>group by contractNumber <BR>having count(*) &#062; 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts