Mavzu: Ma’lumotlarni qayta ishlashda mantiqiy ifodalardan foydalanish Reja

WHERE REP_OFFICE IS NOT NULL
WHERE shartida qo‘shma operatorlar
Izlashning "qo‘shma" shartlarini ko‘rib chiqamiz. WHERE operatorida OR, AND, NOT operatorlari bilan bog‘langan bir necha izlash shartlarini qo‘llash mumkin. Bu operatorlar sintaksisi quyidagicha:
NOT, OR, AND operatorlarning sintaksisi.
(-------- WHERE ----------- SHART -----------------)
(--- NOT ---)
(-------- AND -------------------------)
(-------- OR --------------------------)
Bu operatorlar yordamida yaratilgan bir necha so‘rovlarni ko‘rib chiqamiz.
Masalan: Sotuvlari xaqiqiy xajmi rejadagidan yoki $300.00 dan kam bo‘lgan xizmatchilarni aniqlash
SELECT NAME, QUOTA, SALES
FROM SALESREPS
WHERE SALES < QUOTA OR SALES < 300.0
Sotuvlari xaqiqiy xajmi rejadagidan va $300.00 dan kam bo‘lgan xizmatchilarni aniqlash
SELECT NAME, QUOTA, SALES
FROM SALESREPS
WHERE SALES < QUOTA AND SALES < 300.0
Sotuvlari xaqiqiy xajmi rejadagidan kam, lekin $150.00 dan ko‘p bo‘lgan xizmatchilarni aniqlash
SELECT NAME, QUOTA, SALES
FROM SALESREPS
WHERE (SALES < QUOTA) AND (NOT SALES > 150.000)
AND ifodasi algebrasi.
Qiymat Natija
-------------- ----------
TRUE AND TRUE -> TRUE
FALSE AND TRUE -> FALSE
TRUE AND FALSE -> FALSE
FALSE AND FALSE -> FALSE
NULL AND TRUE -> NULL
TRUE AND NULL -> NULL
FALSE AND NULL -> FALSE
NULL AND FALSE -> FALSE
NULL AND NULL -> NULL
OR ifodasi algebrasi.
Qiymat Natija
-------------- ----------
TRUE OR TRUE -> TRUE
FALSE OR TRUE -> TRUE
TRUE OR FALSE -> TRUE
FALSE OR FALSE -> FALSE
NULL OR TRUE -> TRUE
TRUE OR NULL -> TRUE
FALSE OR NULL -> NULL