日期列的SQL计数 [英] SQL Count for a Date Column

问题描述

我有一个包含一组列的表，其中一个是Date列.

I have a table that containts a set of columns one of it is a Date column.

我需要计算该列的值引用同一月份的次数.并返回如果一个月的总和大于3.

I need to count how many occurrences of the values of that column refer to the same month. And return if for one month, that count sums more than 3.

例如:

____________________
| DATE   |  ....    |
---------------------
1998-09-02
1998-09-03
1998-10-03
1998-10-04

这必须不返回任何值.因为它没有必要的重复次数.

This must return no value. Because it doesn't have the necessary number of repetitions.

但这确实做到了:

____________________
| DATE   |  ....    |
---------------------
1998-09-02
1998-09-03
1998-09-12
1998-09-14
1998-10-02
1998-11-21

11月.

用于Oracle数据库.

Is for an Oracle DB.

推荐答案

SELECT
 COUNT(date)
 , TRUNC(DATE,'MON')
FROM TABLE
GROUP BY TRUNC(DATE,'MON')
HAVING COUNT(DATE) > 3

这篇关于日期列的SQL计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！