तुलना के Operators
Comparison operators values के बीच equality और ordering test करते हैं।
In this page:
Syntax
WHERE column = value
WHERE column <> value
WHERE column BETWEEN a AND b
WHERE column IN (value1, value2)
WHERE column IS NULLComparison Operators
=, <> (या !=), <, <=, >, >=, plus BETWEEN a AND b (inclusive), IN (list), और IS NULL इस्तेमाल करें। NOT BETWEEN, IN, और LIKE invert कर सकता है। Strings database collation के हिसाब से compare होती हैं, इसलिए upper और lower case आपकी उम्मीद से अलग sort हो सकते हैं।
Note:
BETWEEN दोनों boundary values include करता है।
उदाहरण: Comparison operators
CREATE TABLE scores (id INTEGER PRIMARY KEY, name TEXT, points INTEGER);
INSERT INTO scores VALUES (1, 'Ada', 70), (2, 'Bob', 90), (3, 'Cy', 85), (4, 'Di', NULL);
SELECT name FROM scores WHERE points >= 85;
SELECT name FROM scores WHERE points BETWEEN 70 AND 85;
SELECT name FROM scores WHERE name IN ('Ada', 'Di');
SELECT name FROM scores WHERE points IS NULL;
-- Output:
-- name
-- Bob
-- Cy
-- name
-- Ada
-- Cy
-- name
-- Ada
-- Di
-- name
-- DiLogin to try C/C++/Java/PHP code in the editor
Related Topics
{# common_mistakes/chapter_summary/browser_support: on Hindi pages the
view already swaps in the hi_ translation fields (or blanks these
out if untranslated), so this renders correctly for both languages
without a lang_code check here. #}
आम गलतियां
- = की बजाय == इस्तेमाल करना
- यह भूल जाना कि BETWEEN inclusive है
- IS NULL की बजाय = NULL इस्तेमाल करना
चैप्टर सारांश
- = <> < <= > >= values compare करते हैं
- BETWEEN inclusive है
- IN एक list test करता है
- IS NULL missing values test करता है
🔒
Chapter Quiz — Complete all 7 topics to unlock
0/7 topics done
Complete these topics first: