insert into lubbase("序號","根目錄","二級目錄","三級目錄"，"四級目錄","五級目錄","六級目錄","部件名稱","部件型號","單位","裝機數量","潤滑油脂型號","加注量","加注單位","加注日期","加注周期(天)","油脂單價","油脂總價" ) select"序號","根目錄","二級目錄","三級目錄","四級目錄","五級目錄","六級目錄","部件名稱","部件型號","單位","裝機數量","潤滑油脂型號","加注量","加注單位",max("加注日期"),"加注周期(天)","油脂單價","油脂總價",case when dateadd(day,"加注周期(天)",max("加注日期"))>=convert(date,getdate()) then '到期' else '未到期' end from lubtable group by"序號","根目錄","二級目錄","三級目錄","四級目錄","五級目錄","六級目錄","部件名稱","部件型號";
5000行都熬過來了，卡在這里了
uj5u.com熱心網友回復：
你select是不是多一行了，油脂總價后面uj5u.com熱心網友回復：
而且你這個select 會報錯吧uj5u.com熱心網友回復：
1、樓主這應該是SQL SERVER的庫；2、問題應該在group by上？
uj5u.com熱心網友回復：
大神說清楚點啊uj5u.com熱心網友回復：
看了一下你的sql，發現有兩個問題：
1.insert into的列對不上會報錯；
2.select查詢里面的group by用法和你查詢的列不匹配會報錯。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/41672.html
標籤：基礎和管理
上一篇：mysql 弱雞求大佬