Results 1 to 2 of 2

Thread: duplicates?

  1. #1
    Join Date
    Dec 1969

    Default duplicates?

    I wish to query my database for duplicate entries based upon the company name. More specifically, If a company has more than one item for a particular night, I want to display it. How would I accomplish this? I kind of need the reverse of a "SELECT DISTINCT".... thx<BR>~~Chaotix

  2. #2
    Join Date
    Dec 1969

    Default RE: duplicates?

    select company_name from companies group by company_name 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