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

    SELECT * FROM Customers
    ORDER BY Country,CustomerName;

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

    SELECT * FROM Customers
    ORDER BY 
       Country,CustomerName;

• Stacked order items

  • First item in the same line as ORDER BY keyword

    • 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;

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

    • 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;