How I can update only 1000 records in the table using sql?
I need to test backend process for only particular amount of records which I need to update with particular value.(update payment_entered_date only for last 1000 record)
Re: SQL question - how to update only 1000 records?
You can run the update on only records returned in a select statement. If you want to update the first n records returned in a query the method will vary based on the database. Try this link for an explanation of the differences between Oracle, SQl Server and MySQL.