S shiguoxing Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-09 #1 在一段时间内,如何统计每周的销售数量。如在2008-01-01 到 2008-06-30期间每周的数量。
B boy2002cn Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-09 #2 如果是ORACLE就用 select count(1) from rs_da_grda where czsj between date1 and date2 group by to_char(czsj,'iw')
如果是ORACLE就用 select count(1) from rs_da_grda where czsj between date1 and date2 group by to_char(czsj,'iw')