Data Query Language (DQL) can obtain data from tables or views.
GaussDB(DWS) provides statements for obtaining data from tables or views. For details, see SELECT.
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.