Query a Table
Executes a SQL query on a table and returns the result.
Overview
This procedure executes a SQL query on a table and returns the result.
Input Concepts
Concept
Type
Description
Default
Required
table
table
The table to be queried.
No default
Yes
sql query
string
The SQL query to execute on the table, enclosed in quotes. [SQLite syntax]
No default
Yes
Output Concepts
Concept
Description
table
The resulting table after executing the SQL query.
Examples
1. Query a Sample Table
create a sample table
query the table with
the sql query is "SELECT Name, Number, UPPER(Address) AS Address, REPLACE(REPLACE(City, 'San', 'SFO'), 'Jose', 'JOS') AS City FROM sample table"
Last updated
Was this helpful?