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