4. Xodim jadvalidagi F. I
Download 45.5 Kb.
|
Topshiriq
|
Variant GURUH___________. FIO________________________________ 1.Rastalar, mahsulot turi va mahsulot jadvallaridagi rastalar, mahsulot turi va mahsulotustunlari bitta ustunda chiqarilsin___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 2.Mahsulot jadvalining mahsulot narxi ustunining qiymatlarining butun qismi chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 3.Yetkazib beruvchilar jadvalining yetkazib beruvchi ustunidagi <“Alixan”MJCH> qiymati <”VALI” MCHJ> qiymatiga o`zgartirilib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________4. Xodim jadvalidagi F.I.SH ustunida Xasan ismi mavjud bo`lsa undagi X harfi nechchinchi belgi(Simvol)ligi chiqarilsin. ________________________________________________________________________________________________________________________________________________________________________________________ 5. POSITION() ga misol yozing ________________________________________________________________________________________________________________________________________________________________________________________ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Variant GURUH___________. FIO________________________________ 1.Omborxonada keltirilgan sanasi 01.01.2019 dan keying keltirilgan “Fanta” qiymati “Fanta C” ga o`zgartirilib chiqarilsin ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 2. Mahsulotlar jadvalidagi mahsulot nomi ustunidan so`zning boshlanishidagi bo`sh joylash(probellar) olib tashlanib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 3.Yetkazib beruvchilar jadvalining I/CHlar ustunidagi har bir mahsulot sanasiga 1 yil 2 oy qo`shilib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 4. Birinchi rastaga nechta mahsulot turi joylashtirilgan ________________________________________________________________________________________________________________________________________________________________________________________ 5. LOCATION ()ga misol yozing ________________________________________________________________________________________________________________________________________________________________________________________
Variant GURUH___________. FIO________________________________ 1.Mahsulotlar jadvalidagi mahsulot nomi ustunidan bo`sh joylash(probellar) olib tashlanib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 2. Omborxona jadvalining ustunlaridan foydalanib muddati o`tgan mahsulotlar haqida ma`lumot bering ________________________________________________________________________________________________________________________________________________________________________________________ 3.Eng qimmat mahsulot qaysi rastada joylashgan? ________________________________________________________________________________________________________________________________________________________________________________________ 4. Omborxona jadvalining keltirilgansana ustunidagi har bir mahsulot sanasiga 2 oy qo`shilib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 5. NEXT_DAY()ga misol keltiring ________________________________________________________________________________________________________________________________________________________________________________________ Variant GURUH___________. FIO________________________________ 1.Rastalar, mahsulot turi va mahsulot jadvallaridagi rastalar, mahsulot turi va mahsulotustunlari bitta ustunda chiqarilsin___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 2. Mahsulot jadvalining mahsulot narxi ustunining qiymatlarining butun qismi chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 3.Yetkazib beruvchilar jadvalining yetkazib beruvchi ustunidagi <“Alixan”MJCH> qiymati <”VALI” MCHJ> qiymatiga o`zgartirilib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________4. Xodim jadvalidagi F.I.SH ustunida Xasan ismi mavjud bo`lsa undagi X harfi nechchinchi belgi(Simvol)ligi chiqarilsin. ________________________________________________________________________________________________________________________________________________________________________________________ 5. ROUND() ga misol yozing ________________________________________________________________________________________________________________________________________________________________________________________ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Variant GURUH___________. FIO________________________________ 1.Omborxonada keltirilgan sanasi 01.01.2019 dan keying keltirilgan “Fanta” qiymati “Fanta C” ga o`zgartirilib chiqarilsin ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 2. Mahsulotlar jadvalidagi mahsulot nomi ustunidan so`zning boshlanishidagi bo`sh joylar(probellar) olib tashlanib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 3.Yetkazib beruvchilar jadvalining I/CHlar ustunidagi har bir mahsulot sanasiga 1 yil 2 oy qo`shilib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 4. Birinchi rastaga nechta mahsulot turi joylashtirilgan ________________________________________________________________________________________________________________________________________________________________________________________ 5. RAND ()ga misol yozing ________________________________________________________________________________________________________________________________________________________________________________________
Variant GURUH___________. FIO________________________________ 1.Mahsulotlar jadvalidagi mahsulot nomi ustunidan bo`sh joylar(probellar) olib tashlanib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 2. Omborxona jadvalining ustunlaridan foydalanib muddati o`tgan mahsulotlar haqida ma`lumot bering ________________________________________________________________________________________________________________________________________________________________________________________ 3.Eng qimmat mahsulot qaysi rastada joylashgan? ________________________________________________________________________________________________________________________________________________________________________________________ 4. Omborxona jadvalining keltirilgansana ustunidagi har bir mahsulot sanasiga 2 oy qo`shilib chiqarilsin ________________________________________________________________________________________________________________________________________________________________________________________ 5. DATE()ga misol keltiring ________________________________________________________________________________________________________________________________________________________________________________________ Download 45.5 Kb. Do'stlaringiz bilan baham: 
|