How can i set a auto increment value to default value which i like

Question

I had a table with columns serial i want to keep this column as auto-increment from value 1001...

TABLEA

SERIAL NO   | EMPID |   EMPNAME   |    SAL
============================================

1001            1        XXXX         1000

1002            2        YYYY         2000

Answer 1

According to this you can achieve this by issuing:

ALTER SEQUENCE TABLEA_serial_seq RESTART WITH 1001;