[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