DQL Syntax Overview

Data Query Language (DQL) can obtain data from tables or views.

Query

GaussDB(DWS) provides statements for obtaining data from tables or views. For details, see SELECT.

Defining a New Table Based on Query Results

GaussDB(DWS) provides a statement for creating a table based on query results and inserting the queried data into the table. For details, see SELECT INTO.