i need to start row number as 100

[siva125]

i use row_number() in my sql query to generate number from 1...,but i need to start with row number from 100,101 like wise i using sql4.2 navigator ,i use auto increment it show error what to do


insert into ideal_ctry(sele ct row_number() over (order by description asc)) as ncode

but i need start with 100,101...

[ck9663]

Have you tried adding 100100 to the row_number() function?

Good Luck!!!

~~ CK

[nbiswas]

select 100 + row_number() over(.....

Hope this helps