MySQL + SQL · Lesson 46

WHERE Clause and Operators

The WHERE Clause

WHERE filters rows so a query returns only those that match a condition.
SELECT * FROM students WHERE marks >= 90;
Only students with marks 90 or above are returned.

Operators You Can Use

OperatorMeaning
=equal to
!= or <>not equal
> < >= <=comparisons
AND / OR / NOTcombine conditions

Combined Conditions

SELECT name FROM students
WHERE class = '10' AND marks >= 80;

SELECT name FROM students
WHERE class = '9' OR class = '10';

Summary

  • WHERE filters rows by a condition.
  • Use =, !=, >, <, and combine with AND/OR/NOT.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.