学习SQL-2008-10-29

SQL HAVING

SELECT "栏位1",SUM("栏位2")

FROM"表格名"

GROUP BY "栏位1"

HAVING(函数条件)

SQL GROUT BY

SELECT "栏位1",SUM("栏位2")

FROM"表格名"

GROUP BY "栏位1"

SQL ALIAS(别名)

SELECT "表格别名","栏位1" "栏位别名"

FROM "表格名" "表格别名"

SQL 表格链接

SELECT A1.region_name REGION, SUM(A2.Sales) SALES
FROM Geography A1, Store_Information A2
WHERE A1.store_name = A2.store_name
GROUP BY A1.region_name