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

    Option: fmt021_groupby_list_in_newline = false, type: TFmtBoolean.

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

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

    Option: fmt021_groupby_list_in_newline = true, type: TFmtBoolean.

    Option: fmt022_groupby_list_indent = n, type: int.

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

• Stacked items

  Option: fmt020_groupby_list_style = stacked, type: TFmtListStyle.

  • First item in the same line with GROUP BY keyword

    • Comma at the end of line

      Option: fmt023_groupby_list_comma_option = after_item, type: TFmtCommaOption.

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

    • Comma at the begin of line

      Option: fmt023_groupby_list_comma_option = before_item_inside_list, type: TFmtCommaOption.

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

    • Comma at the begin of line, align items

      Option: fmt023_groupby_list_comma_option = before_item_outside_list, type: TFmtCommaOption.

      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

      Option: fmt023_groupby_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

      Option: fmt024_groupby_list_comma_space = n, type: int.

      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