Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Creating a Datasource Connection with an RDS Table> Querying the RDS Table
View PDF

Querying the RDS Table

This statement is used to query data in an RDS 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 to-be-queried table must exist. Otherwise, an error is reported.

Example

Query data in the test_ct table.

1
 
SELECT * FROM dli_to_rds limit 100;