sql="Select top 10 sum(ybtse) as sum1,id_wjdm From swsjb.dbf where (year(date_sjrq)=2002 and month(date_sjrq)=8) group by id_wjdm order by sum(ybtse) desc"
谢谢,我已经解决了,分是一定会给的。 请问各位:如果我的2002或8是用变量代替,该怎么办呢? mm=year(date) nn=month(date) sql="Select top 10 sum(ybtse) as sum1,id_wjdm From swsjb.dbf where (year(date_sjrq)='"&mm&"' and month(date_sjrq)='"&nn&"') group by id_wjdm order by sum(ybtse) desc" 我按上面的SQL语句不行。
sql="Select top 10 sum(ybtse) as sum1,id_wjdm From swsjb.dbf where (year(date_sjrq)='"+mm+"' and month(date_sjrq)='+&nn+"') group by id_wjdm order by sum(ybtse) desc"
请问各位:如果我的2002或8是用变量代替,该怎么办呢?
mm=year(date)
nn=month(date)
sql="Select top 10 sum(ybtse) as sum1,id_wjdm From swsjb.dbf where (year(date_sjrq)='"&mm&"' and month(date_sjrq)='"&nn&"') group by id_wjdm order by sum(ybtse) desc"
我按上面的SQL语句不行。