SQL Server Complete quarter flag

3htmauhk 于 2023-03-11 发布在其他

关注(0)|答案(1)|浏览(151)

I would like to create flag for my data based at complete quarter. Something like this logic:

If passed months in quarter less than 3 then flag N else Y

Month - quarter- full quarter flag

10-2022, q4, y
11-2022, q4, y
12-2022, q4, y
01-2023, q1, n
02-2023, q1, n

Any ideas how to do this?

Thanks

Any ideas with window function etc

sql-server

来源：https://stackoverflow.com/questions/75678142/complete-quarter-flag

1条答案

按热度按时间

zujrkrfu1#

You can use SQL window function and partition by year of the month and quarter number to get the result you want.

Here is the query:

select
    month,
    quarter,
    case when count(1) over (partition by year(month), quarter) >= 3 then 'Y' else 'n' end as full_quarter_flag
from
    data_table

month	quarter	full_quarter_flag
2022-10-01	q4	Y
2022-11-01	q4	Y
2022-12-01	q4	Y
2023-01-01	q1	n
2023-02-01	q1	n

赞(0）回复(0）举报 2023-03-11

我来回答

SQL Server Complete quarter flag

1条答案

相关问题

热门标签

最新问答