Column aliases and derived tables in TSQL 2005 - SQL
SELECT YearMonth, COUNT(JobLogID) AS JobCount FROM
(SELECT JobLogID, CONVERT(VARCHAR(7), JobLogSignOffTimeStamp, 121) AS YearMonth FROM JobLog WHERE JobLogSignOff ='1') AS J GROUP BY YearMonth ORDER BY YearMonth;
No comments:
Post a Comment