Dbm015 guruh talabasi

11.1 – rasm. Sum() agregat funksiyasidan foydalanish

Avg –orta arifmetig
11.2– rasm. Avg() agregat funksiyasidan foydalanish

Min – minimal element
11.3 – rasm. Min() agregat funksiyasidan foydalanish

11.5– rasm. Max() agregat funksiyasidan foydalanib, oxirgi Idni aniqlash
Max esa maxsimal elemntni aniqlaydi
11.6– rasm. Count() agregat funksiyasidan foydalanish

Count esa ustun sonini sanaydi
11.7– rasm. Count() agregat funksiyasi orqali qurilmalar sonini aniqlash

Rand – tasodifiy sonlar
11.8– rasm. Rand() funksiyasidan foydalanish

11.9– rasm. Round() funksiyasidan foydalanish

11.10– rasm. Power() funksiyasidan foydalanish
Power- daraja

11.11– rasm. Sqrt() funksiyasidan foydalanish
Sqrt- kvdrad ildiz

11.12– rasm. Sin() funksiyasidan foydalanish
Sin sonning sinusi


Log sonning lagarifimi
11.13– rasm. Log() funksiyasidan foydalanish

11.14 – rasm. Between() funksiyasidan foydalanish
Between oraliqdagi elementni chiqarish masalan 2 bilan 6 orasidagi elemntni ekranga chiqar deganman tepadagi kodda

11.15 – rasm. Mid() funksiyasidan foydalanish
Mid – satrdagi bosh harfni chiqaradi


Mavzu: Bir nеchta jadvallar birlashtirish, JOINlar bilan ishlash
12.1 - rasm. Inner join qo’llanishi natijasi

12.2 - rasm. Left join qo’llanishi natijasi

12.3 – rasm. Right join qo’llanishi natijasi

12.4– rasm. Cross join qo’llanishi natijasi

Mavzu: Murakkab so‘rovlar yaratish. TOP, LIMIT yoki ROWNUM