Hi All,
Is there a way to create one sequence number for a group of rows with some unique value. For example, if I have a table with a column as below.
| Column1 |
|---|
| 34567 |
| 34567 |
| 34567 |
| 12345 |
| 12345 |
| 12345 |
| 12345 |
| 12345 |
| 12345 |
| 12345 |
I want to select the column and add a sequence number to each row, but the sequence number should be same for all the rows with '34567' as shown in below table.
| Column1 | Sequence |
|---|
| 34567 | 111 |
| 34567 | 111 |
| 34567 | 111 |
| 12345 | 112 |
| 12345 | 112 |
| 12345 | 112 |
| 12345 | 112 |
| 12345 | 112 |
| 12345 | 112 |
| 12345 | 112 |
How can I achieve this?