WHERE Clause and Operators

The WHERE Clause

SELECT * FROM students WHERE marks >= 90;

Operators You Can Use

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.

WHERE Clause

SELECT * FROM students WHERE marks >= 90;

Operators जो Use कर सकते हैं

Combined Conditions

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

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

सारांश

• WHERE condition से rows filter करता है।
• =, !=, >, < use करें और AND/OR/NOT से जोड़ें।