GROUP BY

来源：互联网发布：购物车单价js 编辑：程序博客网时间：2024/04/28 22:55

SELECT "栏位1", SUM("栏位2") FROM "表格名" GROUP BY "栏位1"

在我们的示范上，

Store_Information 表格
store_name Sales Date Los Angeles $1500 Jan-05-1999 San Diego $250 Jan-07-1999 Los Angeles $300 Jan-08-1999 Boston $700 Jan-08-1999

我们就打入，

SELECT store_name, SUM(Sales)
FROM Store_Information
GROUP BY store_name

结果:

store_nameSUM(Sales)Los Angeles$1800San Diego$250Boston$700

group by
group by
group by
group by
group by
group by
GROUP BY
group by
group by
GROUP BY
group by
group by
group by
group by
Group by
group by
group by
group by
linux sd卡驱动分析，基于mini2440，sdio mmc sd卡驱动编写
jsp servlet mysql项目的中文乱码问题
只能输入整数或带小数点的数的正则表达式
linux环境下pppd gprs拨号上网总结
再续java调用动态库so
GROUP BY
MFC 添加右键弹出式菜单
Access数据库的存储上限
信息化建设在管理上的“代价”
Ipconfig 命令详解
InterLockedIncrement and InterLockedDecrement函数原理
sd卡驱动在linux 2.6.24上的实现简易心得及　好的url地址
查看端口号是否被占用(情况命令)
《奋斗》里的十句话