#sequence generation

SQL: Different ways to generate sequence

There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3. Select A =identity(int,1,1),B,C from table_abs 1,A,41 2,B,13 3,C,90 4,D,91 5,E,98 6,F,12 7,G,54 8,H,16 For this output, the 4th column generates the Sequence of numbers from 1 to 3 which is shown below 1,A,41,1 2,B,13,2 3,C,90,3 4,D,91,1 5,E,98,2 6,F,12,3…