CODEWITHSUNDEEP
sqlsql-servert-sql
saran
saran

Reputation: 45

Generate a sequence number for every 3 rows in SQL

I need to generate a sequence number for every three rows with some range. can this be done without iterations.

Example:

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

Upvotes: 3

Views: 1014

Answers (1)

Pரதீப்
Pரதீப்

Reputation: 93734

Use this Analytic function

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

Upvotes: 17

Related Questions