I have table a with fields a.A, a.B, a.C.

I am trying to make table b with fields b.A, b.B, b.C, b.D with a query:

```
SELECT a.A, a.B, a.C, 
(Sequential integers from first record returned to last record returned) AS D 
into b
FROM a WHERE a.C is not null
ORDER BY a.C, a.B DESC, a.A;

```

Sample output of table b:

```
A, B, C, D
9500, 106.12, 9507, 1
9507, 106.12, 9516, 2
9485, 106.11, 9516, 3
9472, 106.1, 9516, 4
9432, 106.09, 9516, 5
9528, 106.14, 9531, 6
9523, 106.13, 9536, 7
9531, 106.14, 9540, 8
9540, 106.14, 9545, 9
9545, 106.14, 9548, 10
9548, 106.14, 9555, 11
9570, 106.21, 9572, 12
9575, 106.22, 9580, 13
9580, 106.22, 9583, 14

```

A is a unique identifier.

This will run on a table with millions of records.

My challenge is with (Sequential ascending integers from first record returned to last record returned). Does anyone have a suggestion on what to put in the parentheses that will help me create table b using only a query?