刚出炉的求解大送分啦!!!一简单的SQL!!来啦,走过,路过,不要错过!! select sum([count]) as [count], [type],[color],[date]from tablenamegroup by [type],[color],[date] 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select sum([count]) as [count], [type],[color],[date]from tablenamegroup by [type],[color],[date]order by sum([count]) desc select sum([count]) as [count], [type],[color],[date]from tablenamegroup by [type],[color],[date]order by [count] desc select sum([count]) [count], [type],[color],[date]from tablenamegroup by [type],[color],[date]order by sum([count]) desc select sum([count]) as [count], [type],[color],[date]from yourtablegroup by [type],[color],[date]order by sum([count]) desc select [type],[color],[date],sum([count]) as [count], from tablenamegroup by [type],[color],[date]order by [date] 求sql server创建用户 关于openrowset的问题 大鸟 ms visio建觉做的库如何导入到sql server里咛? sql server注册问题 请教sql的问题 sql 一个动态行变列的问题 怎么样将SQL Server内的数据库结构导出以便导入另一个机子的SQL Sever数据库中? 系统数据源和用户数据源有什么区别? [在线等待]如何解决ACCESS中SQL的怪字符?(因为很急,所以也发到这来了,请别见怪) SQLServer中解决半个汉字问题
[type],[color],[date]
from tablename
group by [type],[color],[date]
order by sum([count]) desc
[type],[color],[date]
from tablename
group by [type],[color],[date]
order by [count] desc
[type],[color],[date]
from tablename
group by [type],[color],[date]
order by sum([count]) desc
[type],[color],[date]
from yourtable
group by [type],[color],[date]
order by sum([count]) desc
from tablename
group by [type],[color],[date]
order by [date]