Autoinc query

[wickyd]

I have a table with three columns.

I create the table as follows:


SELECT ACCNUM, AREA and NETT INTO AREA1 FROM ALLAREA
WHERE AREA = '01';


I now want to add a fourth column, a AUTOINC column which starts at 1 and ends at the last row.

How do I add this row?

I am using DBISAM V3.21

Thank you.
wickyd

 

[PHV]

Take a look at ranking query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[r937]

SELECT identity(int,1,1) as AUTOINC
, ACCNUM, AREA, NETT
INTO AREA1
FROM ALLAREA
WHERE AREA = '01';


rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)