You can use row number () to create ids for all the rows and then based on any column order you can delete 1000 rows:

DELETE FROM

(SELECT ROW_NUMBER()

OVER (ORDER BY Empcode) AS Row,

Name, Address, Idno

FROM Table_name) AS tablename

WHERE Row<=1000