Results 1 to 2 of 2

Thread: Update SQL

  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Update SQL

    Hi Folks,

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

    Thanks,
    Panditt

  2. #2
    Join Date
    Oct 2010
    Posts
    14

    fetch first x rows only

    this would work..

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •