| MySQL

Home

SELECT AVG(column_name) FROM table_name

Пример SQL

O_Id	OrderDate	OrderPrice	Customer
1	2008/11/12	1000	Hansen
2	2008/10/23	1600	Nilsen
3	2008/09/02	700	Hansen
4	2008/09/03	300	Hansen
5	2008/08/30	2000	Jensen
6	2008/10/04	100	Nilsen

1	SELECT AVG(OrderPrice) AS OrderAverage FROM Orders

Query Result:


950

1 2	SELECT Customer FROM Orders WHERE OrderPrice>(SELECT AVG(OrderPrice) FROM Orders)

Query Result:

+5 #1 Шелест Константин 2010-10-28 23:07 ATP huge)))

Address	Dmitry Kupriyanov Kramatorsk Ukraine
E-mail	ageent.ua @ gmail.com ageent.ru @ gmail.com
Phone	Mobile: +380 54 501 90 28 Home: +380 626 44 10 998
Websites	www.ageent.ru