U: Standart funksiyalardan foydalanib so‘rovlar yaratish Ish

3. Bu ikki jadvalni UNION ALL yordamida birlashtiramiz.
So`rov:
SELECT * FROM xodimlari
UNION ALL
SELECT * FROM marketing_xodimlari;
Natija:


4. INTERSECT yordamida jadvallar kesishmasini topamiz;


So`rov:
SELECT *FROM xodimlari
INTERSECT
SELECT *FROM marketing_xodimlari;
Natija:

5. MINUS yordamida 1-jadvalimizdan ikkinchisini ayirish amalini bajaramiz:
SELECT *FROM xodimlari
MINUS
SELECT *SELECT marketing_xodimlari;
Natija: