Skip to content

Space inside parenthesis of subquery

Tako Lee edited this page Mar 11, 2014 · 2 revisions
  • No space

    Option: fmt097_space_padding_subquery_parenthesis = false, type: TFmtBoolean.

    SELECT last_name  
    FROM   employees  
    WHERE  salary > (SELECT salary  
                     FROM   employees  
                     WHERE  last_name = 'Abel'); 
  • One space

    Option: fmt097_space_padding_subquery_parenthesis = true, type: TFmtBoolean.

    SELECT last_name  
    FROM   employees  
    WHERE  salary > ( SELECT salary  
                      FROM   employees  
                      WHERE  last_name = 'Abel' ); 
Clone this wiki locally