SQL align option

Option used to align main keywords or list items.

• Align left

  • Align main keywords

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id  

  • Align list items

  CREATE TABLE dbo.mytable ( low  int,
                             high int, 
                             myavg AS (low + high)/2 ) ;  

• Align Right

  • Align main keywords

   SELECT e.employee_id, 
          d.location_id  
     FROM employees e,departments d  
    WHERE e.department_id = d.department_id  

  • Align list items

  CREATE TABLE dbo.mytable (   low int,
                              high int, 
                             myavg AS (low + high)/2 ) ;