AI engineering glossary · SQL databases
What is WHERE?
WHERE: The clause that filters rows before any grouping, keeping only those for which its condition is true. It can combine comparisons with AND, OR and NOT. Filtering early reduces the work later steps do.
WHERE: an example
SELECT * FROM orders WHERE amount > 500 AND city = 'Delhi'; keeps only large Delhi orders.
Related terms
More SQL databases terms
Where you learn it
WHERE is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.