sql group by order by
Posted on 2007-11-30
I have a statement which I need to add a order by to but can't figure out the correct way to do it, here is my statement.
I need to sort by dateentered
SELECT CONVERT(varchar, dateentered, 101) AS [Date], COUNT(*) AS Qty
where dateentered >= DATEADD(DAY, -10, GETDATE())
GROUP BY CONVERT(varchar,dateentered, 101)