Where clause

• Condition in the same line as WHERE keyword

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

  • AND/OR keyword at the end of line

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id AND
         e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with condition

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id
         AND e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with WHERE keyword

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id
    AND  e.last_name = 'Matos';  

• Condition in new line, indented from 1 to n

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

  • AND/OR keyword at the end of line

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
    e.department_id = d.department_id AND
    e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with condition

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
    e.department_id = d.department_id
    AND e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with WHERE keyword

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
      e.department_id = d.department_id
  AND e.last_name = 'Matos';