SQL TABLE EXPRESSION

DB2 SQL TABLE EXPRESSION : BASIC


SQL TABLE EXPRESSION

SQL TABLE EXPRESSION gives you power to create a temporary table inside a query. Life of this temporary table is only inside that query. As soon as query is completed temporary table will be vanished.

This is a very useful and powerful concept and can help you solve very complex issue with very simple queries.

There are 2 types of TABLE EXPRESSIONs in DB2 SQL

  1. Nested table expressions(also called Derived tables)
  2. Common table expressions

IBM i developer.

View Comments
There are currently no comments.