我想根据khbh来分组。
string SQLStatement="Select a.KHBH,a.Company_NM,a.JYFW,b.Cont_Cnm,b.Cont_Enm,b.Cont_Sex,b.Cont_Tel,b.Cont_Email,b.Cont_Moible,b.Depart,b.job from Company_Infor as a ,Customer_Infor as b where a.KHBH=b.KHBH and a.KHBH='"+khbh+"'";
...全文
1354打赏收藏
如何分组 !
我想根据khbh来分组。 string SQLStatement="Select a.KHBH,a.Company_NM,a.JYFW,b.Cont_Cnm,b.Cont_Enm,b.Cont_Sex,b.Cont_Tel,b.Cont_Email,b.Cont_Moible,b.Depart,b.job from Company_Infor as a ,Customer_Infor as b where a.KHBH=b.KHBH and a.KHBH='"+khbh+"'";
zjcxc(邹建)
max是求最大的吧。
我这样放报错,具体怎么放呀。请多多指教。
Select a.KHBH,Max(a.Company_NM,a.JYFW,b.Cont_Cnm,b.Cont_Enm,b.Cont_Sex,b.Cont_Tel,b.Cont_Email,b.Cont_Moible,b.Depart,b.job )from Company_Infor as a ,Customer_Infor as b where a.KHBH=b.KHBH and a.KHBH='"+khbh+"' group by a.khbh";