AND

A logical test that will only include rows where both conditions are true.

Code Example

Suppose we want to get current students with GPA higher than 3.0:

SELECT *
FROM students
WHERE enrolled_status = 'current' AND overall_gpa >= 3.0
Edit this page on GitHub

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your feedback.

Learn SQL on Codecademy

Edit this page on GitHub

Contributors