Guruhi talabasining

So`rov: select*from oquv_ishlari 
-> full outer join orindosh_xodimlar 
-> on oquv_ishlari.F_I_SH=orindosh_xodimlar.F_I_SH; 
Natija: 
+------+-------------------+----------+----------------+------------+-----------+-------+ 
| id | F_I_SH | lavozimi | telefon_raqami | manzili | ish_vaqti | staji | 
+------+-------------------+----------+----------------+------------+-----------+-------+ 
| 1 | yoldasheva_gulnoz | oqtuvchi | 934990989 | Pop tumani | abetgacha | 2 | 
| 2 | sharipov_diyorbek | oqtuvchi | 935821478 | Pop tumani | abetgaha | 3 | 
| 3 | Rahimov_Bobur | oqtuvchi | 935821412 | Pop tumani | abetgaha | 5 | 
| 2 | Ikromov_iskandar | oqtuvchi | 935821652 | Pop tumani | abetgaha | 3 | 
| 2 | Xasanov_jasurbek | oqtuvchi | 935825252 | Pop tumani | abetgaha | 3 | 
| 6 | Yunusov_Temur | oqtuvchi | 935821552 | Pop tumani | abetgaha | 2 | 
| 2 | Salimova_ogloy | oqtuvchi | 935825452 | Pop tumani | abetgaha | 3 | 
+------+----------------------+----------------+-------------+--------------+-------+ 
+------+----------------------+----------------+-------------+--------------+-------+ 
| 1 | Yunusov_alisher | 935821552 | 9 | 3 | 2 | 
| 2 | arslonov_alisher | 935822552 | 10 | 7 | 2 | 
| 3 | Mamasoliyeva_Mohira | 942821552 | 9 | 2 | 2 | 
| 4 | arslonov_Davron | 935142551 | 10 | 7 | 3 | 
| 4 | Sultonov_Botirjon | 935142254 | 10 | 7 | 3 | 
| 6 | Sarvarov_Bahodirjon | 935142222 | 10 | 7 | 3 | 
| 7 | Otamirzayev_Izzatila | 942821514 | 9 | 2 | 2 | 
+------+----------------------+----------------+-------------+--------------+-------+
 
 
 
 
 

---

13 - LABORATORIYA ISHI 
Mavzu: Murakkab so‘rovlar yaratish. TOP, LIMIT yoki ROWNUM 
Nazariy ma`lumotlar 
SQL LIMIT va SQL TOP operatorlarining vazifasi belgilangan satrlarni 
chaqirishdan iborat. SQL TOP operatori MS SQL Serverda ishlaydi, SQL LIMIT 
operatori esa MySQLda va Oracle da ROWNUM operatori ishlaydi ularnig vazifasi 
bir hil.