SQL WHERE

SQL Where clause is used to filter records in a database table, allowing you to retrieve only the rows that meet specific conditions.


Tutorials dojo strip

SQL Where Syntax

SQL


SQL Where Examples

SQL Where Filtering by a Single Condition Example

This query retieves all columns from the students table for rows where the NAME starts with the letter ‘A’.

SQL


SQL Where Combining Multiple Conditions with AND

This query retrieves all columns from the PATIENTS table for rows where the gender is ‘M’ (male) and the contact_number is not NULL.

SQL


SQL Where Using OR to Broade the Search

This query retrieves all columns from the DOCTORS table for rows where the specialty is either ‘Cardiology’ or ‘Neurology’.

SQL


SQL Where Visual Diagram


SQL Where Labs

Tutorials dojo strip