SQL SERVER - 참조 - 함수 - AVG()

AVG()

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

⭐ NULL 값은 무시한다.

SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse에서 작동한다.

AVG(expression)

매개변수

expression

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

SELECT AVG(Price) AS AveragePrice FROM Products;

기본 예시

AveragePrice
28.8663

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

기본 예시

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
7	Uncle Bobs Organic Dried Pears	3	7	12 – 1 lb pkgs.	30.0000
8	Northwoods Cranberry Sauce	3	2	12 – 12 oz jars	40.0000
9	Mishi Kobe Niku	4	6	18 – 500 g pkgs.	97.0000
10	Ikura	4	8	12 – 200 ml jars	31.0000
12	Queso Manchego La Pastora	5	4	10 – 500 g pkgs.	38.0000
17	Alice Mutton	7	6	20 – 1 kg tins	39.0000
18	Carnarvon Tigers	7	8	16 kg pkg.	62.5000
20	Sir Rodneys Marmalade	8	3	30 gift boxes	81.0000
26	Gumbär Gummibärchen	11	3	100 – 250 g bags	31.2300
27	Schoggi Schokolade	11	3	100 – 100 g pieces	43.9000
28	Rössle Sauerkraut	12	7	25 – 825 g cans	45.6000
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	123.7900
32	Mascarpone Fabioli	14	4	24 – 200 g pkgs.	32.0000
38	Côte de Blaye	18	1	12 – 75 cl bottles	263.5000
43	Ipoh Coffee	20	1	16 – 500 g tins	46.0000
51	Manjimup Dried Apples	24	7	50 – 300 g pkgs.	53.0000
53	Perth Pasties	24	6	48 pieces	32.8000
56	Gnocchi di nonna Alice	26	5	24 – 250 g pkgs.	38.0000
59	Raclette Courdavault	28	4	5 kg pkg.	55.0000
60	Camembert Pierrot	28	4	15 – 300 g rounds	34.0000
62	Tarte au sucre	29	3	48 pies	49.3000
63	Vegie-spread	7	2	15 – 625 g jars	43.9000
64	Wimmers gute Semmelknödel	12	5	20 bags x 4 pieces	33.2500
69	Gudbrandsdalsost	15	4	10 kg pkg.	36.0000
72	Mozzarella di Giovanni	14	4	24 – 200 g pkgs.	34.8000

W3C School - SQL AVG() Function

W3C School - SQL Tutorial

Mingg`s Diary

밍구

공부 목적 블로그