Number rows 1, 2, 3, 1, 2, 3...ect-CodePudding

Home > Blockchain > Number rows 1, 2, 3, 1, 2, 3...ect

Number rows 1, 2, 3, 1, 2, 3...ect

Time：01-29

SELECT ROW_NUMBER() OVER() AS levels, 
       name 
FROM players_table

The above gives me the following

However, I'm looking to do this (start counting 1-3 every 3 rows) while still preserving the order.

CodePudding user response：

You can take the modulus

SELECT (ROW_NUMBER() OVER() % 3)   1 AS levels, 
       name 
FROM players_table

CodePudding user response：

select * from  (select (row_number() over() %4) levels,
           name
         from
           players_table)t
where levels > 0