SELECT CONVERT(VARCHAR(10),DATEFIELD1,120) AS DATE1,SUM(AMOUNT) FROM TABLE1
GROUP BY DATE1SELECT CONVERT(VARCHAR(10),DATEFIELD1,120) AS DATE1,SUM(AMOUNT) FROM TABLE1
GROUP BY CONVERT(VARCHAR(10),DATEFIELD1,120)
为何只能用第二种写法,有没有简单的?
GROUP BY DATE1SELECT CONVERT(VARCHAR(10),DATEFIELD1,120) AS DATE1,SUM(AMOUNT) FROM TABLE1
GROUP BY CONVERT(VARCHAR(10),DATEFIELD1,120)
为何只能用第二种写法,有没有简单的?
order by 是在确定了记录集之后再按照一定的规律排 那时候是可以用别名的 group by不可以