Finding the minimum date for every month in a table.
Hi, I have a table that stores the date for every day of the month. I need to get the minimum date for every month thats in the table. So, my table shows the report as below 7/1/2008 7/28/2008 7/29/2008 7/30/2008 7/31/2008 8/4/2008 8/5/2008 8/6/2008 8/7/2008 I just need to pick the minimum date in those months meaning i just need to see 7/1/2008 and 8/4/2008 in my query result. How do i do it? Thank you.
October 23rd, 2010 9:45pm
One method: SELECT MIN(MyDate) AS MyDate FROM dbo.MyTable GROUP BY DATEADD(month, DATEDIFF(month, '19000101', MyDate), '19000101'); Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
October 23rd, 2010 9:57pm
Perfect. Thank you.
October 23rd, 2010 10:11pm