10 amaliy ishi. Agrеgat funksiyalardan foydalanish

Download 0,56 Mb. Pdf ko'rish
bet	3/6
Sana	04.12.2023
Hajmi	0,56 Mb.
	#110695

1 2 3 4 5 6

Bog'liq
mb amaliy 3
EldorDB, MsoIrmProtector, AL Mustaqil ish 1, 618083, QO\'CHQOROVA, 1. Ikki o lchovli integral, uning xossalari, geometrik va mexani, 1. “Uzliksizta’limkonsepsiyasi”birinchimartakimtomonidantahlil q, 1-mustaqil ish mdya tranzistorlar asosidagi integral mikrosxemal, 1. Iqtisodiyot Hisobga olish, statistika va hisobot]-www.hozir.org, Modda tuzilishi, CamScanner 2023-12-02 23.27, TLA-8-Oliy matematika 1, 3-мавзу, 6-Mavzu Kreditning turlari va shakllari

CREATE DATABASE — ma’lumotlar bazasini yaratish huquqi;
CREATE DEFAULT — jadval ustunlari uchun standart qiymatlarni o‘rnatish huquqi;
CREATE PROCEDURE — saqlanadigan protseduralarni yaratish huqiqi;
CREATE ROLE — jadval ustunlari uchun qoidalarni o‘rnatish huquqi;

CREATE TABLE — jadvallarni yaratish huquqi;
CREATE VIEW — obyekt tasvirlarini yaratish huquqi;
BACKUP DATABASE — zahira nusxalarni yaratish huquqi;
BACKUP TRANSACTION — tranzaktsiyalar zaxira nusxasini yaratish huquqi.

ISHNI BAJARISH:
1.SUM(); select sum(yoshi) as 'Xodimlarning yoshlari yigindisi' from ustozlar;
2.AVG(); select avg(ish_staji) as 'ustozlarning ortacha reytingi' from ustozlar;
3. MIN(); select min(yoshi) as 'eng yosh oqituvchi', FIO from ustozlar;

4.MAX(); select max(ish_staji) as 'eng ish staji katta ustoz' from ustozlar;

5.COUNT(); select count(*) as 'kollejdagi kafedralar soni' from kafedra;
6&7. RAND(); & ROUND(); select id, FIO, round(rand(yoshi)*100, 0) as 'random yosh'
from xodim;
8.BETWEEN(); select id, FIO, yoshi from ustozlar where yoshi between 23 and 40;
9.MID(); select mid(FIO, 1, 3) as 'boshidagi 3ta harf', FIO from ustozlar;
11 – Amaliy ish. Murakkab so‘rovlar yaratish

SQL LIMIT va SQL TOP operatorlarining vazifasi belgilangan satrlarni
chaqirishdan iborat. SQL TOP operatori MS SQL Serverda ishlaydi, SQL LIMIT
operatori esa MySQLda va Oracle da ROWNUM operatori ishlaydi ularning vazifasi
bir hil.

SQL Server / MS Access Syntax:
SELECT TOP number|percent column_name(s)
FROM table_name
WHERE condition; MySQL

Download 0,56 Mb.

1 2 3 4 5 6

Download 0,56 Mb.

Pdf ko'rish