What does WHERE department = ‘Sales’ indicate in the following SQL query?

Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz | 

What does WHERE department = ‘Sales’ indicate in the following SQL query?

SELECT * FROM employees WHERE department = ‘Sales’;

  • To only return rows that match the filter
  • To change all the values in the department column to ‘Sales’
  • To only return the department column
  • To highlight the department column in the results

 

Leave a Comment