Home Forums SQL Server 2012 SQL 2012 - General DELETE FIRST 1000 ROWS RE: DELETE FIRST 1000 ROWS

  • March 29, 2014 at 7:56 am

    #1701370

    shashianireddy (3/29/2014)

    I HAVE TABLE LIKE BELOW 3000 ROWS

    NAME ADDRESS IDNO EMPCODE

    SVR HYD 123456 9876

    SGH HSD 98765 987654

    .

    .

    .

    .

    I WANT DELETE FIRST 1000 ROWS IN SQL TABLE ............................

    PLZ WRITE QUARIE ..........

    In SQL Server there really is no concept of first 1000 rows. So first question, how are you going to determine what are the first 1000 rows? By what column are you going to order the data and are you ordering it in ascending or descending order?

    Here is a start:

    DELETE TOP (1000) FROM MyTable ORDER BY yourOrderingColumn