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

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

Пример SQL

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

1
2
3

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

SUM()
1700

Теперь мы хотим узнать, имеют ли клиенты "" и "" заказ на сумму более 1500.

1
2
3
4

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

SUM()
2000
2000

Autorización

Bo Ajax Poll

Estatística

Anuncio
© 2009 ageent.ru.