Nested Table Expression

Description

A fullselect in parentheses is called a nested table expression. The intermediate result table is the result of that fullselect.

Click here arrow-up-rightto navigate to the IBM DB2 docs page for this syntax.

circle-exclamation

Grammar Syntax

Sample Source Patterns

Supported cases

IBM DB2

Snowflake

IBM DB2

Snowflake

IBM DB2

Snowflake

Unsupported cases

IBM DB2

Snowflake

  1. MSCEWI1002arrow-up-right: REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.

Last updated

Was this helpful?