kwbtblog https://blog.hatena.ne.jp/kwbtblog/ Welcome to new things https://www.ekwbtblog.com/ Azure DATE_TRUNC MSSQL SQL SQL Database SQL Server data analysis To aggregate data by month/week, first find the beginning date of the month/week of the date and GROUP by that beginning date. If the DATE_TRUNC() function can be used to get the head date, such as Google BigQuery, you can aggregate the data as follows. SELECT DATE_TRUNC(dt, MONTH) AS dt_month ,SUM(… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ekwbtblog.com%2Fentry%2F2019%2F09%2F13%2F152749" title="How to do monthly/weekly aggregation in SQL Server - Welcome to new things" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> https://cdn-ak.f.st-hatena.com/images/fotolife/k/kwbtblog/20190627/20190627001546.png Hatena Blog https://hatena.blog 2019-09-13 15:27:49 rich https://www.ekwbtblog.com/entry/2019/09/13/152749 1.0 100%