Amaliy ish-4-5-6


Download 1.3 Mb.
Pdf ko'rish
bet5/5
Sana24.11.2022
Hajmi1.3 Mb.
#930041
1   2   3   4   5
Bog'liq
4-практика№4, Algebra va matematik analiz fanidan lug at (R.Yarqulov, M.Barakayeva), Маъмуралиев Авазбек 1, Мустакил иш, Мустакил иш, Амалиёт-15, fulltext, sss, civil proj advt, civil proj advt, problem, integral tenglamalarni yechish metodlari — копия, VLSI Implementation of Cellular Neural N, Sayt nomi, Sayt nomi
+------+---------+ 
2 rows in set (0.00 sec) 
 
mysql> select*from sportzal order by sportturi; 
+------+-------------------+-----------+--------------+---------+ 
| id | nomi | sportturi | qurilgansana | harajat | 
+------+-------------------+-----------+--------------+---------+ 
| 1 | bunyodkorstadioni | futbol | 2010-10-20 | 50000 | 
| 3 | humoarena | hokkey | 2010-10-20 | 40000 | 
+------+-------------------+-----------+--------------+---------+ 
2 rows in set (0.00 sec) 
mysql> select*from sportzal having harajat>40000; 
+------+-------------------+-----------+--------------+---------+ 
| id | nomi | sportturi | qurilgansana | harajat | 
+------+-------------------+-----------+--------------+---------+ 
| 1 | bunyodkorstadioni | futbol | 2010-10-20 | 50000 | 
+------+-------------------+-----------+--------------+---------+ 
1 row in set (0.00 sec) 






Download 1.3 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2022
ma'muriyatiga murojaat qiling