[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)


Why is the ordering in the GROUP BY clause important in this query?

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list