Operators
SQL operatorlari
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 |
Last updated on