select datess,zhudan,mudi,fahuo,shouhuoren,num,jifeiweight,hangkong,baozhuang,tongguan,denghou,chaozhong,other,zonge from chugang group by datess order by esc运行报错----试图执行的查询中不包含作为合计函数一部分的特定表达式 'zhudan' 。请高手赐教
调试欢乐多
from chugang
group by datess
其他列不需要分组,就在分组的查询中去掉。
select datessou
from chugang
group by datess
lz给个数据,和要求的结果吧!
from chugang
order by CONVERT(VARCHAR(10),datess,120) desc
if object_id('[TB]') is not null drop table [TB]
create table [TB]([id] int,[pm] varchar(6),[sl] int,[rkry] varchar(2))
insert [TB]
select 1,'桌子',3,'aa' union all
select 2,'凳子',4,'aa' union all
select 3,'椅子',6,'bb' union all
select 4,'文件夹',8,'aa' union all
select 5,'传真纸',2,'cc' union all
select 6,'水性笔',5,'bb'select * from [TB]WITH TT AS(
SELECT
id = row_number () OVER(PARTITION BY rkry order BY rkry asc),rkry,
pm
FROM TB
GROUP BY rkry,pm)SELECT [Group]=CASE WHEN id = 1 THEN rkry ELSE '' END ,pm
FROM TT
/*
Group pm
----- ------
aa 凳子
文件夹
桌子
bb 水性笔
椅子
cc 传真纸(6 行受影响)
*/参考下看看,row_number语句SQL2k5的环境可用。 SQL2000不可。
sum(zhudan),
sum(mudi),
sum(fahuo),
sum(shouhuoren),
sum(num),
sum(jifeiweight),
sum(hangkong),
sum(baozhuang),
sum(tongguan),
sum(denghou),
sum(chaozhong),
sum(other),
sum(zonge)
from chugang
group by convert(varchar(10),datess,120) 不能sum的就用max