|
Rand() - tasodifiy son.
So’rov: Select id, name, rand(id) from xodimlar
|
bet | 6/7 | Sana | 11.12.2023 | Hajmi | 251,73 Kb. | | #116217 |
Bog'liq 10-amaliy ish Cho\'lpon, 97, ТЕСТ РЗА РУС, 1-5-lab, pdf 20230523 130211 1, Luxury Hotel Business Plan by Slidesgo, 2823 islomuz, amirbrend, brend ogilcha, portal.guldu.uz-VIRTUAL MUZEYLAR VA ULARNING AHAMIYATI, LMS лек 2, 2-laboratoriya ishi, yakuniy, RAQ amaliyotRand() - tasodifiy son.
So’rov: Select id, name, rand(id) from xodimlar;
Natija:
11.6– rasm. Rand() funksiyasidan foydalanish
7. ROUND() - Butun sonni yaxlitlash funktsiyasi.
So`rov: Select id, name, round(salary/id, 3) from xodimlar;
Natija:
11.7– rasm. Round() funksiyasidan foydalanish
8. POWER() - Sonning darajasini hisoblash.
Select id, salary, power(salary, id) from xodimlar;
Natija:
11.8– rasm. Power() funksiyasidan foydalanish
9. SQRT() - Sonning kvadrat ildizini topish.
So`rov:Select id, sqrt(id) from xodimlar;
Natija:
11.9– rasm. Sqrt() funksiyasidan foydalanish
10. SIN() - Ifoda sinusini hisoblash.
So`rov: Select id, sin(id) from xodimlar;
Natija:
11.10– rasm. Sin() funksiyasidan foydalanish
11. LOG()- Sonnig natural logarifmni hisoblash.
So`rov: Select id, log(id) from xodimlar;
Natija:
11.11– rasm. Log() funksiyasidan foydalanish
12. BETWEEN() - ko`rsatilgan oraliqdagi ma’lumotlarni chiqarish.
“qurilma” jadvalidan IDsi 2 va 4 oralig’ida bo’lgan qurilma ma’lumotlari chiqaramiz;
So`rov: Select *from xodimlar where id between 2 and 4;
Natija:
11.12 – rasm. Between() funksiyasidan foydalanish
13. MID()- ustundagi yozuvlarning bosh harfini shiqarish.
“qurilma” jadvalidagi qurilma nomlarini bosh harflarini va qurilma nomini chiqaramiz.
So`rov: Select mid(name,1,1) as ‘bosh harflar’, lname from xodimlar;
|
| |