AND operator tests if all conditions in a given expression evaluate to
SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 ... AND conditionN;
If any of the
condition_s evaluate to
NOT TRUE, then the entire
WHERE clause will not return the desired
THe following example filters the current students with GPA higher than 3.0 for the rest of the
SELECT *FROM studentsWHERE enrolled_status = 'current' AND overall_gpa >= 3.0
Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to create and optimize a database from scratch using PostgreSQL
Includes 5 Courses