分享至
Excel程式引用sql,下列程式只能統計整天資料,想要用資料內的時間值分上下午select A.機號,count(甲張數) as 次數上午,sum(甲張數) as 甲張數上午,sum(乙張數) as 乙張數上午,sum(丙張數) as 丙張數上午,乙張數上午/甲張數上午 as 比率上午 from [機號$] as A left Outer join [資料$] as B on A.機號=B.機號 group by A.機號希望把hour(時間)>12的條件加進去sql程式內謝謝
已邀請的邦友 {{ invite_list.length }}/5
IT邦幫忙