select
--ROWID ,
(select count(*) from VisionTemplate b where a.id >= b.id) as row_number
,
*
from VisionTemplate as a
order by id;
select
--ROWID ,
(select count(*) from VisionTemplate b where a.id >= b.id) as row_number
,
*
from VisionTemplate as a
order by id;