[thelist] CF & SQL: Selecting unique months from date column

rudy rudy937 at rogers.com
Wed Jul 16 17:24:43 CDT 2003


> SELECT
> DISTINCT Month(your_date_field) AS themonth
> FROM your_calendar_table
> ORDER BY your_date_field

some databases will not let you sort a result set on a field that isn't in
the result set

when you use DISTINCT you automatically force a sort anyway, so you can just
omit the ORDER BY

however, DISTINCT often gets people into trouble (not that it doesn't work,
it's just that people do not fully understand how it works), so i recommend
the GROUP BY solution that Tab submitted


rudy



More information about the thelist mailing list