Nwenar Ismail

Nwenar Ismail

  • NA
  • 83
  • 4.6k

sql identity num starts randomly

May 20 2021 3:34 AM
i have a table which has an id column for  auto increment num for each row 
but my Id num is starts  from a number randomly 
 
here is my table 
my column called ID  which  I want to count for each row from 1 to infinitebut it doesn't start from 1 
it starts from a random number 
thanks 
 

Answers (3)