sql查询按月的天分组 [英] sql query group by day of month

问题描述

我有一个记录表，其中包含创建的行的日期. (oracle db)

I have a record table that icludes dates of rows created. (oracle db)

ID    City       CreateDate
1     city-1     12.12.2017
1     city-2     13.12.2017
1     city-1     13.12.2017
1     city-3     12.12.2017
....
....

我想在一个月内创建一份每日报告.例如12月天数的City-1报告

I want to create a daiy report in a month. For example City-1 report by days in December

Day    Count
1      10
2      80
3      60
4      10
...
30     11

推荐答案

我认为您可以将提取函数与count函数一起使用:

I think you can use extract with count functions:

SELECT EXTRACT(day FROM CreateDate) "Day",
      COUNT(CreateDate) "Number of Reports"
      FROM yourTableName
      GROUP BY EXTRACT(day FROM CreateDate)
      ORDER BY "Number of Reports" ASC;

这篇关于sql查询按月的天分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！