Exam LX0-104 topic 7 question 4 discussion

The word used to restrict the records that are returned from a SELECT SQL query based on a supplied criteria for the values in the records is "WHERE". The WHERE clause is used to filter the records based on specific conditions. For example, you can use the WHERE clause to return only the records where the value of a certain column is greater than a certain number or where the values of two columns match. In a SELECT query, the basic syntax for using the WHERE clause is as follows: SELECT column1, column2, ... FROM table_name WHERE condition;