SQL Aggregate Function, Like, Between va In tushunchalarini Bilmaganlar Ko'rsin!

Описание: 00:00 - 00:36 – NULL Values – NULL qiymatlar nima va ular bilan qanday ishlash kerak
04:02 – SELECT TOP – Natijani cheklash, yuqoridan eng birinchi N ta yozuvni olish
04:32 – COUNT() – Qatorlar sonini hisoblash
06:43 – MIN() – Eng kichik qiymatni topish
07:18 – MAX() – Eng katta qiymatni aniqlash
08:02 – SUM() – Qiymatlarni qo‘shish
08:32 – AVG() – O‘rtacha qiymatni hisoblash
09:19 – LIKE operatori – Matnli qidiruv
14:15 – WILDCARDS – LIKE bilan mos yozuvlarni topish (%, _, regex uslubidagi qidiruv)
22:30 – IN operatori – Ro‘yxat ichida qiymat bor-yo‘qligini tekshirish
24:19 – IN (SELECT) – Subquery bilan IN ishlatish
26:00 – BETWEEN – Oraliqda bo‘lgan qiymatlarni tanlash

Foydali havolalar:

Linkedin Sahifam:
  / elbek-normurodov-58712017a  

Telegram Kanalim:
https://t.me/ElbekningCSharpDarslari

Telegram Guruh:
https://t.me/DasturlashniOrganamizUz