Group Every 3 Years?

Question

Hi Everyone. I'm having trouble trying to get my data to display properly. For every three years, I need to add the year to a new group. Here's an example:

2018 - 1
2019 - 1
2020 - 1
2021 - 2
2022 - 2
2023 - 2
2024 - 3
2025 - 3
2026 - 3
2027 - 4
2028 - 4
2029 - 4

Any help would be greatly appreciated. Thank you.

Answer 1

Guessing that you have a table like this:

declare @years as table ( [year] int )

insert @years values
( 2018 ),
( 2019 ),
( 2020 ),
( 2021 ),
( 2022 ),
( 2023 ),
( 2024 ),
( 2025 ),
( 2026 ),
( 2027 ),
( 2028 ),
( 2029 )

check this query:

select *, (dense_rank() over (order by [year]) - 1) / 3 + 1 as [group]
from @years
order by [year]