SQL Operatorlari
SQL Aritmetik Operatorlari
Operator | Tavsif |
---|---|
+ | Qo'shish |
- | Ayirish |
* | Ko'paytirish |
/ | Bo'lish |
% | Modulo |
SQL Bitwise Operatorlari
Operator | Tavsif |
---|---|
& | Bitwise AND |
| | Bitwise OR |
^ | Bitwise eksklyuziv OR |
SQL Taqqoslash Operatorlari
Operator | Tavsif |
---|---|
= | Teng |
> | Katta |
< | Kichik |
>= | Katta yoki teng |
<= | Kichik yoki teng |
<> | Teng emas |
SQL Murakkab Operatorlari
Operator | Tavsif |
---|---|
+= | Qo'shish teng |
-= | Ayirish teng |
*= | Ko'paytirish teng |
/= | Bo'lish teng |
%= | Modulo teng |
&= | Bitwise AND teng |
^= | Bitwise eksklyuziv teng |
|= | Bitwise OR teng |
SQL Mantiqiy Operatorlari
Operator | Tavsif |
---|---|
ALL | Agar subquery qiymatlari shartga mos kelsa, TRUE |
AND | Agar AND bilan ajratilgan barcha shartlar TRUE bo'lsa |
ANY | Agar subquery qiymatlaridan hech biri shartga mos kelsa, TRUE |
BETWEEN | Agar operand taqqoslashlar oralig'ida bo'lsa, TRUE |
EXISTS | Agar subquery bitta yoki bir nechta yozuvlarni qaytarsa, TRUE |
IN | Agar operand ro'yxatdagi ifodalardan biriga teng bo'lsa, TRUE |
LIKE | Agar operand naqshga mos kelsa, TRUE |
NOT | Shart(lar) TRUE emas bo'lsa, yozuvni ko'rsatadi |
OR | Agar OR bilan ajratilgan shartlardan biri TRUE bo'lsa, TRUE |
SOME | Agar subquery qiymatlaridan hech biri shartga mos kelsa, TRUE |