How to update only first 1000 rows of a table

[deshaipet]

Hi Folks,

I would like to update only first 1000 rows of a table. Can anyone help me with the SQL ?

Thanks,
Panditt

[thesmithman]

Hi Panditt,
If this is a one-time operation, I would probably use a simple for loop that iterates a thousand times and increments through the record numbers. Alternatively, if your records are numbered sequentially, you could do something like

UPDATE table WHERE id<1000

It's not very fancy but it just might get you through.

Happy coding!

[Anand Kaushal]

You could also use something like this, in case there are gaps in the sequence and you want to set a particular column to the same value..

UPDATE TABLE SET COL = VALUE
WHERE ID IN (SELECT ID FROM TABLE ORDER BY ID FETCH FIRST 1000 ROWS ONLY);

Thesmithman's options are perfect too btw - depends what you've gotta accomplish.