The SQL select statement where clause can be used to select rows by means of operator words. For example, we can specify a range of values using "between" or a set of values using "in".
To learn how to use the where clause and its associated operator words on an SQL select statement, follow these steps:
betweenoperator word. Rows with population values in the range of 1,000,000 to (and including) 2,000,000 will be selected.
inoperator word is used to define the set of state abbreviation values we want to select from the table.