sql="select top 30 username,c_name,MAX(pro_date) AS last_date from gong GROUP BY c_name,username order by MAX(pro_date) desc"
pro_date是日期,我想选取当天的数据,那个条件要怎么写啊?
where datevalue(pro_date)=date()这样写是不对的!
...全文
15711打赏收藏
怎么写这个查询条件????
sql="select top 30 username,c_name,MAX(pro_date) AS last_date from gong GROUP BY c_name,username order by MAX(pro_date) desc" pro_date是日期,我想选取当天的数据,那个条件要怎么写啊? where datevalue(pro_date)=date()这样写是不对的!