What are the usage of SELECT statements in DB2 databases? What is the effect?

Today we are going to discuss with you three advanced usage of SELECT statements in DB2 databases. We all know that SELECT statements are the most important statements in database queries, this article describes the advanced usage of the three SELECT statements.

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.

The above content is the description of the three advanced usage of the SELECT statement of the DB2 database. I hope it will help you in this aspect.