报错缺失表达式，哪位大神帮我看看？

Question

insert into lubbase("序号","根目录","二级目录","三级目录"，"四级目录","五级目录","六级目录","部件名称","部件型号","单位","装机数量","润滑油脂型号","加注量","加注单位","加注日期","加注周期(天)","油脂单价","油脂总价" ) select"序号","根目录","二级目录","三级目录","四级目录","五级目录","六级目录","部件名称","部件型号","单位","装机数量","润滑油脂型号","加注量","加注单位",max("加注日期"),"加注周期(天)","油脂单价","油脂总价",case when dateadd(day,"加注周期(天)",max("加注日期"))>=convert(date,getdate()) then '到期' else '未到期' end  from lubtable group by"序号","根目录","二级目录","三级目录","四级目录","五级目录","六级目录","部件名称","部件型号";
5000行都熬过来了，卡在这里了

Answer 1

你select是不是多一行了，油脂总价后面

Answer 2

而且你这个select 会报错吧

Answer 3

1、楼主这应该是SQL SERVER的库；
2、问题应该在group by上？

Answer 4

看了一下你的sql，
发现有两个问题：
1.insert into的列对不上会报错；
2.select查询里面的group by用法和你查询的列不匹配会报错。