Group By

Results 1 to 2 of 2

Thread: Group By

  1. #1
    Join Date
    Dec 1969

    Default Group By

    Does anybody know...Can a group by be done without an aggragate function (count, sum, etc). I'm using a SQL statement to populate a datalist but I have multiple entries and want to get rid of those. The group by isn't working and I'm wondering what is wrong.

  2. #2
    Join Date
    Dec 1969

    Default Use DISTINCT instead

    SELECT DISTINCT fld1, fld2, fld3, ...<BR><BR>

Posting Permissions

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