I have vendor table with the following column, refvendor_id, the refvendor_id is a primary key in the table. the customer use the application to enter information to the vendor table using an interface
created in Java. my question is how can I query the refvendor_id numbers that have been skipped by the customer when they enter information to the vendor table.
refvendor_id is a varchar data type.
for example
refvenodr_id
1
2
3
5
6
9
I would like to capture in my sql the refvendor_id that is skipped here.
4,7,8
select refvendor_id
from vendor