Fizika-matematika fakulteti

-- SUM ------------- ( --- ifoda ---------------- ) ----------------------

bet	55/86
Sana	03.11.2021
Hajmi	1.36 Mb.
	#170223

1 ... 51 52 53 54 55 56 57 58 ... 86

Bog'liq
sql tilini oqitishda usulbiy xususiyatlar taxlili

-- COUNT ------------- ( --------------------- ustun nomi)
SELECT AVG(100 * (SALES/QUOTA))

-- SUM ------------- ( --- ifoda ---------------- ) ----------------------

-- DISTINCT – ustun nomi ---

-- AVG ------------- ( --- ifoda ---------------- ) ----------------------

-- DISTINCT -- ustun nomi ---

-- MIN ------------- ( ifoda ) -------------------------------------------

-- MAX ------------- ( ifoda ) -------------------------------------------

-- COUNT ------------- ( --------------------- ustun nomi) ---------------

-- DISTINCT --

-- COUNT(*) -------------------------------------------------------------------

Agregatlash argumenti bo‗lib ustun nomidan tashqari ixtiyoriy matematik

ifoda xizmat qilishi mumkin. Misol uchun quyidagi so‗rovda: Sizni

kompaniyangizda reja bajarilishi o‗rtacha protsenti qancha?

SELECT AVG(100 * (SALES/QUOTA))

Download 1.36 Mb.

Do'stlaringiz bilan baham:

1 ... 51 52 53 54 55 56 57 58 ... 86