SQL Where Clause Review
Last Updated: September 17, 2020 9:17:16 AM PDT
Give feedback
See how SQL where clauses work.
In SQL, where clauses set the search conditions in a select statement.
Note: If you don't know the SQL programming language, you can use QueryLink by clicking the Queries button in FinancialLink, EmployeeLink, Student/ Class Info tools, and DataLink.
Remember, if you have more than one search condition within your statement, you must connect them with AND or OR.
| Search condition | Usage |
|---|---|
| between | Specifies a numeric range that includes the endpoints in a chosen row:
where column_name between value1 AND value2
|
| in [not in] | Includes or excludes a particular set of data that matches one of a list of values:
where column_name in(value1,value2,value3)
|
| like [not like] | Like compares two character strings for a partial match:
Percent sign (%) — any string of characters, 0 or more characters in length
Not like retrieves all rows that do not satisfy a partial match.Underscore (_) — any single character |
| null | Finds all rows where the value in the selected column is null:
where column_name is (not) null
|
| all, any | All retrieves all data within the specified table. Any retrieves more specific data in the relevant search. |
| exists [not exists] | Use in conjunction with a subquery to determine if the relevant data exists. If so, the exists condition is satisfied, and the search is conducted for specified data within a table. |
For more detailed instructions on SQL, enroll in a SQL training class.
For more information, contact the Data Warehouse team.