Create sequnce number for every 3 rows in SQL

Question

I need to create sequence number

for each three rows

with some range. it can be done without iteration.

Example:

sequence
--------
1
1
1
2
2
2
3
3
3

+3

saran 01 jan. At 4:17 am

1 answer

P ரதீப் · Accepted Answer · 2015-01-01T04:19:42+0000

Use Analytic function

SELECT ( ( Row_number()OVER(ORDER BY order_by_column ) - 1 ) / 3 ) + 1 seq_no,
              *
       FROM   tablename