SELECT d_turnover_report.saledate, d_turnover_report.total FROM d_turnover_report INNER JOIN retail_pay ON d_turnover_report.saledate = CONVERT(varchar(10), retail_pay.saledate, 120) WHERE (retail_pay.saledate > '2003-7-14 12:00:00') group by d_turnover_report.saledate, d_turnover_report.total
to taiguang(银狐) : 用group by是个好办法,谢谢。但是不知道这样费不费时间to hdhai9451(※★開拓者...脚妞伤了☆※): 其实问这个问题,就想知道“用distinct比較耗時”这句话,谢谢。但是如果能给出原因就更好了,呵呵
把query time-out(sec 0=unlimited) 設置查詢時間大一點
FROM d_turnover_report INNER JOIN
retail_pay ON d_turnover_report.saledate = CONVERT(varchar(10),
retail_pay.saledate, 120)
WHERE (retail_pay.saledate > '2003-7-14 12:00:00')
group by d_turnover_report.saledate, d_turnover_report.total
用group by是个好办法,谢谢。但是不知道这样费不费时间to hdhai9451(※★開拓者...脚妞伤了☆※):
其实问这个问题,就想知道“用distinct比較耗時”这句话,谢谢。但是如果能给出原因就更好了,呵呵