如何计算从特定行开始的表的所有行

how to count all the rows of a table starting from specific row by id?

like

SELECT COUNT(*) FROM aptec ORDER BY id ASC AFTER id = 1000;

is that possible ?

Try

SELECT COUNT(*) FROM aptec WHERE id > 1000