[thelist] CF & SQL: Selecting unique months from date column
Joshua Olson
joshua at waetech.com
Thu Jul 17 16:05:17 CDT 2003
----- Original Message -----
From: "Tab Alleman" <Tab.Alleman at MetroGuide.com>
Sent: Thursday, July 17, 2003 4:49 PM
> SELECT Month(DateColumn), Year(DateColumn)
> FROM TableName
> GROUP BY Year(DateColumn), Month(DateColumn)
> (the order of the GROUP BY clause is important)
Tab,
Why is the ordering in the GROUP BY clause important in this query?
<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com
706.210.0168
More information about the thelist
mailing list