Group by clause

• All items in the same line

  Option: fmt020_groupby_list_style = fit_into_one_line, type: TFmtListStyle.

  • First item in the same line with GROUP BY keyword

    SELECT Subject, Semester, Count(*)
    FROM [Subject_Selection]
    GROUP BY Subject,Semester

  • First item in new line, indented by 1 or n

    SELECT Subject, Semester, Count(*)
    FROM [Subject_Selection]
    GROUP BY 
      Subject,Semester

• Stacked items

  • First item in the same line with GROUP BY keyword

    • Comma at the end of line

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY Subject,
               Semester

    • Comma at the begin of line

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY Subject
               ,Semester

    • Comma at the begin of line, align items

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY Subject
              ,Semester

    • Comma at the begin of line, align items, space between comma and item is 1 or n

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY Subject
             , Semester

  • First item in new line, indented by 1 or n

    • Comma at the end of line

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY 
        Subject,
        Semester

    • Comma at the begin of line

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY 
         Subject
         ,Semester

    • Comma at the begin of line, align items

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY 
         Subject
        ,Semester

    • Comma at the begin of line, align items, space between comma and item is 1 or n

      SELECT Subject, Semester, Count(*)
      FROM [Subject_Selection]
      GROUP BY 
          Subject
        , Semester