Generating a numeric pattern in query result set
Based on your comments you will be ordering the results by date. In that case you could use

ROW_Number () over( order by date) 


Which would output the row numbers.  You could then use the SQL Modulo function, % and perform a %3 which would give you 1,2,0 repeating as the row output which gives you the grouping you want.