SQL operatorlar
SQL operatorlari
SQL operatorlari - bu ma’lumotlar qiymatlari bilan operatsiyalarni bajarish uchun ishlatiladigan kalit so‘zlar va belgilar.
SQL operatorlari (masalan, LIKE) SELECT, WHERE, LIKE va hokazo kabi SQL buyruqlarida ishlatiladi.
SQL operatorlari quyidagi turlarga bo‘linadi:
- Arifmetik operatorlar
- Taqqoslash operatorlari
- Murakkab operatorlar
- Bitli operatorlar
- Mantiqiy operatorlar
SQL arifmetik operatorlari
| Operator | Tavsif | Misol |
|---|---|---|
| + | Addition | Try it |
| - | Subtraction | Try it |
| * | Multiplication | Try it |
| / | Division | Try it |
| % | Modulus | Try it |
SQL solishtirish operatorlari
| Operator | Tavsif | Misol |
|---|---|---|
| = | Teng | Try it |
| > | Katta | Try it |
| < | Kichik | Try it |
| >= | Katta yoki teng | Try it |
| <= | Kichik yoki teng | Try it |
| <> | Teng emas | Try it |
SQL birikma operatorlari
| Operator | Tavsif |
|---|---|
| += | Add equals |
| -= | Subtract equals |
| *= | Multiply equals |
| /= | Divide equals |
| %= | Modulo equals |
| &= | Bitli AND bilan o‘zlashtirish |
| ^= | Bitwise exclusive equals |
| |*= | Bitli OR bilan o‘zlashtirish |
Bitwise SQL operatorlari
| Operator | Tavsif |
|---|---|
| & | Bitli AND |
| | | Bitli OR |
| ^ | Bitli istisno qiluvchi OR (XOR) |
| ~ | Bitli NOT |
SQL mantiqiy operatorlari
| Operator | Tavsif | Misol |
|---|---|---|
| ALL | Agar barcha quyi so‘rov qiymatlari shartga javob bersa, TRUE | Try it |
| AND | AND bilan ajratilgan barcha shartlar TRUE bo‘lsa, TRUE | Try it |
| ANY | Agar quyi so‘rov qiymatlaridan birortasi shartga javob bersa, TRUE | Try it |
| BETWEEN | Agar operand taqqoslash oralig‘ida bo‘lsa, TRUE | Try it |
| EXISTS | Agar quyi so‘rov bir yoki bir nechta yozuvni qaytarsa, TRUE | Try it |
| IN | Agar operand ifodalar ro‘yxatidan biriga teng bo‘lsa, TRUE | Try it |
| LIKE | Operand andozaga mos kelsa, TRUE | Try it |
| NOT | Shart(lar) TRUE bo‘lmasa, yozuvni ko‘rsatadi | Try it |
| OR | OR bilan ajratilgan shartlardan biri TRUE bo‘lsa, TRUE | Try it |
| SOME | Agar quyi so‘rov qiymatlaridan birortasi shartga javob bersa, TRUE | Try it |
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!