Results 1 to 2 of 2

Thread: Group By 1?

  1. #1
    Join Date
    Aug 2004
    Posts
    19

    Unanswered: Group By 1?

    What does "GROUP BY 1" do in Informix?

    I'm used to grouping by column names.

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    group by 1 will group by the first field in the select clause

    if you say select * ... group by 1
    this will group by the first field in the table

Posting Permissions

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