SQL Month Loop

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Highlighted
Fan

SQL Month Loop

Hello

I got three columns and how to repeast month no value starting from 1 to 12 and count value (10) must repeat same value, do we have to write loop in sql..?

Year,month_No, Count

2017    1              10

2017    2              10

 

vs