MS Access - 참조 - 함수 - Avg()

Avg()

Avg() 함수는 표현식의 평균 값을 반환한다.

⭐ NULL 값은 무시된다.

Access 2000에서 작동한다.

Avg(expression)

매개변수

expression

숫자 값(필드 또는 공식일 수 있음)

SELECT Avg(Price) AS AveragePrice FROM Products;

기본 예시

AveragePrice
28.8664

SELECT * FROM Products
WHERE Price > (SELECT Avg(Price) FROM Products);

기본 예시

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
7	Uncle Bob’s Organic Dried Pears	3	7	12 – 1 lb pkgs.	30
8	Northwoods Cranberry Sauce	3	2	12 – 12 oz jars	40
9	Mishi Kobe Niku	4	6	18 – 500 g pkgs.	97
10	Ikura	4	8	12 – 200 ml jars	31
12	Queso Manchego La Pastora	5	4	10 – 500 g pkgs.	38
17	Alice Mutton	7	6	20 – 1 kg tins	39
18	Carnarvon Tigers	7	8	16 kg pkg.	62.5
20	Sir Rodney’s Marmalade	8	3	30 gift boxes	81
26	Gumbär Gummibärchen	11	3	100 – 250 g bags	31.23
27	Schoggi Schokolade	11	3	100 – 100 g pieces	43.9
28	Rössle Sauerkraut	12	7	25 – 825 g cans	45.6
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	123.79
32	Mascarpone Fabioli	14	4	24 – 200 g pkgs.	32
38	Côte de Blaye	18	1	12 – 75 cl bottles	263.5
43	Ipoh Coffee	20	1	16 – 500 g tins	46
51	Manjimup Dried Apples	24	7	50 – 300 g pkgs.	53
53	Perth Pasties	24	6	48 pieces	32.8
56	Gnocchi di nonna Alice	26	5	24 – 250 g pkgs.	38
59	Raclette Courdavault	28	4	5 kg pkg.	55
60	Camembert Pierrot	28	4	15 – 300 g rounds	34
62	Tarte au sucre	29	3	48 pies	49.3
63	Vegie-spread	7	2	15 – 625 g jars	43.9
64	Wimmers gute Semmelknödel	12	5	20 bags x 4 pieces	33.25
69	Gudbrandsdalsost	15	4	10 kg pkg.	36
72	Mozzarella di Giovanni	14	4	24 – 200 g pkgs.	34.8

W3C School - SQL Avg() Function

W3C School - SQL Tutorial

Mingg`s Diary

밍구

공부 목적 블로그