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?