By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

i need to start row number as 100

P: 9
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(select row_number() over (order by description asc)) as ncode

but i need start with 100,101...
Feb 1 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
Have you tried adding 100100 to the row_number() function?

Good Luck!!!

~~ CK
Feb 1 '10 #2

P: 149
select 100 + row_number() over(.....

Hope this helps
Mar 24 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.