sql select rows between 1000 and 2000 code example

Example: sql select rows between 1000 and 2000

SELECT TOP 1000 column_id
FROM (SELECT TOP 2000 column_id
		FROM table_name ORDER BY column_id ASC) sub
 ORDER BY sub.column_id DESC