常用Sql示例

group by having语法：

select column1,       column2from table1,     table2where [ conditions ]group by column1,         column2 having [ conditions ]order by column1,         column2;

例子：

select Customer,       SUM(OrderPrice)from Orderswhere Customer='Bush'  or Customer='Adams'group by Customer having SUM(OrderPrice)>1500;