LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Combined Table
    • Get a Table from a File
  • Rows
    • Get Rows
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Query a Table
    • Sort a Table
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Manipulations

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"
Name
Number
Address
City

John

+1 (415) 691 9426

123 EAST STREET

SFO Francisco

Joe

+1 (415) 691 1234

321 WEST STREET

SFO JOS

Jack

+1 (415) 691 4595

213 NORTH STREET

SFO Francisco

Last updated 21 days ago

Was this helpful?