Filtering with AND

The AND operator is used to filter rows only when multiple conditions are true.

Syntax

SELECT column1, column2 FROM table_name WHERE condition1 AND condition2;

Example Finding students in the Computer Science department AND with a GPA above 3.5

SELECT * FROM Students WHERE Department = 'Computer Science' AND GPA > 3.5;

Question number:

Up Next: Practice Filtering with OR

Donate

About

Privacy Policy

Changelog