Grouping numbers

Results 1 to 2 of 2

Thread: Grouping numbers

  1. #1
    Join Date
    Dec 1969

    Default Grouping numbers

    I want to group a number of records based on their duplication and the number of times they appear. For example, I have a db of numbers and I want to group all the numbers that are the same but only appear twice, or group all the numbers that are the same but appear three times, etc.<BR><BR>All the numbers are random, so I cannot specify in the SQL which numbers to select.<BR><BR>Thanks<BR><BR>-Houston<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default That's just a..

    .. SELECT query where you specify a GROUP BY number_field and then say HAVING COUNT(number_field) = 2<BR><BR>Pull up a SQL reference, it&#039;s actually a pretty simple query.

Posting Permissions

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