Published May 7, 2021Updated Aug 18, 2022
Contribute to Docs
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
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
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 query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses