On this page

Querying the DWS Table

Updated on 2023-11-03 GMT+08:00

This statement is used to query data in a DWS table.

Syntax

1
SELECT * FROM table_name LIMIT number;

Keyword

LIMIT is used to limit the query results. Only INT type is supported by the number parameter.

Precautions

The table to be queried must exist. Otherwise, an error is reported.

Example

To query data in the dli_to_dws table, enter the following statement:

1
SELECT * FROM dli_to_dws limit 100;
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback