mysql> SELECT javobgar_xodim FROM mashinalar INTERSECT SELECT nazoratchi_xodim FROM xomashyo;
+-----------------+
| javobgar_xodim |
+-----------------+
| Behzod Keldiyev |
+-----------------+
1 row in set (0.00 sec)
(MINUS opertori MySql 8.0 da deprecate ga uchragan uning o`rniga shu vazifani
bajaruvchi EXCEPT operatori
mavjud)
mysql> SELECT javobgar_xodim FROM mashinalar EXCEPT SELECT nazoratchi_xodim FROM xomashyo;
+-------------------+
| javobgar_xodim |
+-------------------+
| Abdulla Komilov |
+-------------------+
1 row in set (0.00 sec)
mysql>
Dostları ilə paylaş: