这个group by 语句怎么老是不对啊？
0
悬赏园豆：100
[待解决问题]
select count(id) as lei,sum(productnum)as num,max(is_validate) as is_validate,
max(add_date) as add_date,dingdan,warehouse_id,warehouse_in,Max(isPrint) as Isprint,
ROW_NUMBER() OVER ( Order by add_date desc ) AS RowNumber
From
WareHouse_change
where
warehouse_in=1 and zhuangtai=1 and ordertype=0
group by dingdan,warehouse_id,warehouse_in
所有回答(5)
0
帮你查询分析器中测试了: The command(s) completed successfully.
没有发现什么问题呀
0
试试
where
zhuangtai=1 and ordertype=0
group by dingdan,warehouse_id,warehouse_in
having warehouse_in=1
0
改成下面的语句试试看：
select *,ROW_NUMBER() AS RowNumber from
(select count(id) as lei,sum(productnum)as num,max(is_validate) as is_validate,
max(add_date) as add_date,dingdan,warehouse_id,warehouse_in,Max(isPrint) as Isprint
From
WareHouse_change
where
warehouse_in=1 and zhuangtai=1 and ordertype=0
group by dingdan,warehouse_id,warehouse_in)
(select count(id) as lei,sum(productnum)as num,max(is_validate) as is_validate,
max(add_date) as add_date,dingdan,warehouse_id,warehouse_in,Max(isPrint) as Isprint
From
WareHouse_change
where
warehouse_in=1 and zhuangtai=1 and ordertype=0
group by dingdan,warehouse_id,warehouse_in)
0
表结构 发上来看看!
0
ROW_NUMBER() OVER ( Order by add_date desc ) AS RowNumber
窗口函数中add_date 没有包含在聚合函数或 GROUP BY 子句中