Wagwoord <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value

Есть следующая таблица "Bestellings":

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

1
2
3

SELECT ,SUM() FROM Bestellings
GROUP BY 
HAVING SUM()<2000

	SUM ()
	1700

SELECT ,SUM() FROM Bestellings
WHERE = OR =
GROUP BY 
HAVING SUM()>1500

	SUM ()
Hansen	2000
	2000

Address
E-pos	ageent.ua @ gmail.com ageent.ru @ gmail.com
Phone	Mobile: +380 54 501 90 28
Websites	Afdruk

Main Menu

Magtiging

Nice Ajax Poll

Statistiek

Line

Adverteer