sql operatorlari guruhi

PPTX 25 pages 476.3 KB Free download

25 pages

FaylHub.uz

Download via Telegram

Size 476.3 KB

File type PPTX

Pages 25

Updated Dec 2025

Page preview (5 pages)

Scroll down 👇

1 / 25

sql tili. sql operatorlarini yozish. 1. umumiy tushuncha va atamalar 2. sql operatorlari tasnifi 3. sql ning asosiy operatorlari 4. sodda so’rovlar yaratish 26.04.2024 ma’lumotlar manipulyatsiya qilish. oddiy so‘rovlar yaratish. 1 sql xfa: [ˈɛsˈkjuˈɛl] structured query language ma'lumotlar bazasida yangi jadval yaratish; jadvalga yangi yozuvlar qo'shish; yozuvlarni o'zgartirish; yozuvlarni o'chirish; bir yoki bir nechta jadvallardan yozuvlarni tanlash (berilgan shartga muvofiq); jadval tuzilmalarini o'zgartirish. sql operatorlari guruhi 3 ddl (data definition language) create alter dml (data manipulation language) select insert dcl (data control language) grant revoke tcl (transaction control language) drop update delete deny commit rollback savepoint insert into goods (good_id, good_name, type) select 20, 'table', 2; insert into goods (good_id, good_name, type) values (20, 'table', 2); sodda so’rovlar yaratish “team” jadvalidagi barcha ma’lumotlarni chiqarish “*” - barcha ustunlardagi ma’lumotlarni degani. natija: select * from team; agar barcha ustundagi ma’lumotlar emas, ba’zi birlari kerak bo‘lsa, kerakli ustun nomlari vergul orqali nomma-nom …

2 / 25

aks holda xatolik yuzaga keladi. select * from test where ism=‘david‘; natija: “test” jadvalidagi, yoshi 20 dan kichik bo‘lgan insonlarning familiyasini chiqaruvchi so‘rov quyidagicha bo‘ladi: select familiya from test where yosh ‘david‘ ; yoki select * from test where ism != ‘david‘ ; natija: yoshi 20 dan 25 gacha bo‘lgan insonlarning maoshini chiqarish select maosh from test where yosh between 20 and 25 ; natija: yoshi 18 va 30 ga teng bo‘lgan ism va familiyalarni ekranga chiqarish select maosh from test where yosh in (18, 30) ; natija: maoshi kiritilmagan ustunga tegishli bo‘lgan boshqa ustun ma’lumotlarini chiqarish select maosh from test where maosh is null ; natija: like va mantiqiy operatorlar(and, or, not) main nomli talabalar jadvalidan farg’ona viloyatida tug’ilgan talabalar ro’yhatini chiqarish. select lname, fname, bpcode from main where bpcode like '%an%' main nomli talabalar jadvalidan vodiylik talabalar ro’yhatini chiqarish. select lname, fname, bpcode from main where bpcode like …

3 / 25

4 / 25

5 / 25

Want to read more?

Download all 25 pages for free via Telegram.

Download full file

About "sql operatorlari guruhi"

sql tili. sql operatorlarini yozish. 1. umumiy tushuncha va atamalar 2. sql operatorlari tasnifi 3. sql ning asosiy operatorlari 4. sodda so’rovlar yaratish 26.04.2024 ma’lumotlar manipulyatsiya qilish. oddiy so‘rovlar yaratish. 1 sql xfa: [ˈɛsˈkjuˈɛl] structured query language ma'lumotlar bazasida yangi jadval yaratish; jadvalga yangi yozuvlar qo'shish; yozuvlarni o'zgartirish; yozuvlarni o'chirish; bir yoki bir nechta jadvallardan yozuvlarni tanlash (berilgan shartga muvofiq); jadval tuzilmalarini o'zgartirish. sql operatorlari guruhi 3 ddl (data definition language) create alter dml (data manipulation language) select insert dcl (data control language) grant revoke tcl (transaction control language) drop update delete deny commit rollback savepoint insert into goods (good_id, good_name,...

This file contains 25 pages in PPTX format (476.3 KB). To download "sql operatorlari guruhi", click the Telegram button on the left.

Tags: sql operatorlari guruhi PPTX 25 pages Free download Telegram