Order by clause

• Order items fit in the same line

  Option: fmt027_orderby_list_style = fit_into_one_line, type: TFmtListStyle.

  • First item in the same line as ORDER BY keyword

    Option: fmt028_orderby_list_in_newline = false, type: TFmtBoolean.

    SELECT * FROM Customers
    ORDER BY Country,CustomerName;

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

    Option: fmt028_orderby_list_in_newline = true, type: TFmtBoolean.

    Option: fmt029_orderby_list_indent = n, type: int.

    SELECT * FROM Customers
    ORDER BY 
       Country,CustomerName;

• Stacked order items

  Option: fmt027_orderby_list_style = stacked, type: TFmtListStyle.

  • First item in the same line as ORDER BY keyword

    • Comma at the end of line

      Option: fmt030_orderby_list_comma_option = after_item, type: TFmtCommaOption.

      SELECT * FROM Customers
      ORDER BY Country,
               CustomerName;

    • Comma at the begin of line

      Option: fmt030_orderby_list_comma_option = before_item_inside_list, type: TFmtCommaOption.

      SELECT * FROM Customers
      ORDER BY Country
               ,CustomerName;

    • Comma at the begin of line, align items.

      Option: fmt030_orderby_list_comma_option = before_item_outside_list, type: TFmtCommaOption.

      SELECT * FROM Customers
      ORDER BY Country
              ,CustomerName;

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

      Option: fmt030_orderby_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

      Option: fmt031_orderby_list_comma_space = n, type: int.

      SELECT * FROM Customers
      ORDER BY Country
             , CustomerName;

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

    Option: fmt028_orderby_list_in_newline = true, type: TFmtBoolean.

    Option: fmt029_orderby_list_indent = n, type: int.

    • Comma at the end of line

      SELECT * FROM Customers
      ORDER BY 
        Country,
        CustomerName;

    • Comma at the begin of line

      SELECT * FROM Customers
      ORDER BY 
        Country
        ,CustomerName;

    • Comma at the begin of line, align items.

      SELECT * FROM Customers
      ORDER BY 
         Country
        ,CustomerName;

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

      SELECT * FROM Customers
      ORDER BY 
         Country
       , CustomerName;