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
- Nested table expressions(also called Derived tables)
- Common table expressions