Asosiy matnga o'tish
sqlmaster.uzsqlmaster.uz

84. Rekursiv: sotuvsiz kunlarni to'ldirish

Qiyin
CTE & RecursiveExpress24

Sotuvlar jadvalida ba'zi kunlar umuman yo'q (o'sha kuni sotuv bo'lmagan).

Eng erta sanadan eng kech sanagacha barcha kunlarni ko'rsating —

sotuv bo'lmagan kunlarda summa 0 bo'lsin.

Ustunlar: sale_date, amount.

Saralash: sale_date o'sish.

Jadval: sales

UstunTuri
sale_dateDATE PK
amountNUMERIC(12,2)

Namuna ma'lumotlar

sample
sales
sale_dateDATEamountNUMERIC(12,2)
2025-04-01100000
2025-04-03250000
2025-04-0680000
Kutilgan natija
amountsale_date
1000002025-04-01
02025-04-02
2500002025-04-03
02025-04-04
02025-04-05
800002025-04-06
sample-full
sales
sale_dateDATEamountNUMERIC(12,2)
2025-04-25100000
2025-04-26250000
2025-04-2980000
2025-05-01420000
2025-05-02310000
2025-05-06175000
2025-05-07260000
Kutilgan natija
amountsale_date
1000002025-04-25
2500002025-04-26
02025-04-27
02025-04-28
800002025-04-29
02025-04-30
4200002025-05-01
3100002025-05-02
02025-05-03
02025-05-04
02025-05-05
1750002025-05-06
2600002025-05-07
sample-extra
sales
sale_dateDATEamountNUMERIC(12,2)
2025-04-06120990.09
2025-04-02496700
2025-04-12175000
2025-04-09260000
2025-04-24226300
Kutilgan natija
amountsale_date
4967002025-04-02
02025-04-03
02025-04-04
02025-04-05
120990.092025-04-06
02025-04-07
02025-04-08
2600002025-04-09
02025-04-10
02025-04-11
1750002025-04-12
02025-04-13
02025-04-14
02025-04-15
02025-04-16
02025-04-17
02025-04-18
02025-04-19
02025-04-20
02025-04-21
02025-04-22
02025-04-23
2263002025-04-24

O'xshash masalalar

So'rovni ishga tushirish uchun hisobingizga kiring.
Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.