Limitations of I/U/D

While I/U/D statements support most of the same functionality as the SELECT statement, there are a few caveats to keep in mind:

  • Local filtering: I/U/D statements do not support local filtering.
  • Sub-selects: INSERT statements do not support sub-selects.
  • Paging: I/U/D statements do not support paging. However, you can use sub-selects within UPDATE and DELETE statements to narrow down the values you wish to insert or delete, as shown in the following example:

    DELETE FROM table WHERE guid IN (SELECT guid FROM social.connections WHERE owner_guid = me)

Table of Contents