Three alternative usage of SELECT in DB2 database

This article mainly describes the three advanced usage of SELECT statements in the DB2 database. We all know that SELECT statements are important statements for database queries, this article mainly introduces the advanced usage of three different 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.

The above content describes the three advanced usage methods of the SELECT statement of the DB2 database. We hope it will help you in this aspect.