Order By

Description

Specifies the order of the rows for application of the offset-clause and fetch-clause.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

DELETE FROM table1 ORDER BY colum1

Snowflake

DELETE FROM
PUBLIC.table1
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE ORDER BY OPTION **
--ORDER BY colum1
  1. MSCEWI1002: Removed next statement, not applicable in SnowFlake

Last updated

Was this helpful?