Links

SQL Commands

Command Name
Description
SELECT
The SELECT statement is used to select data from a database. Spice supports querying using standard SELECT statements.
USE
The USE command enables you to specify the context to be used for the current query session.
SHOW
DESCRIBE
The DESCRIBE TABLE command is used to provide high-level information regarding the overall column properties of an existing dataset.
WITH
The WITH clause defines a common table expression (CTE), which is a temporary named result set. The definition of a CTE includes its name, an optional list of column names, and a query expression (that is, a SELECT statement).
Last modified 1mo ago