Advanced usage of SELECT statement 3 in DB2 database

The following articles mainly describe the advanced usage of SELECT statement 3 in the DB2 database. In actual operations, SELECT statements are very important statements for database queries, this section describes the advanced usage of the three SELECT statements.

The SELECT statement is an important statement for database query. The advanced usage of the three SELECT statements is described here.

1. Create a result table

 
 

  
  
create table new_table_name as (select * from table_name) definition only; 
 
 

2. Create a materialized query table (MQT)

 
 

  
  
create table new_table_name as (select * from table_name) data initially deferred refresh deferred; refresh table new_table_name; 
 
 

Note: The SELECT statement of a materialized table is similar to a Query. The table is not actually formed and the type is displayed as Query. But it can be used as a table.

3. Copy the table structure

 
 

  
  
create table new_table_name like table_name; 
 
 

The above content is an introduction to the three advanced usage methods of the SELECT statement in the DB2 database. I hope you will gain some benefits.