Comment on page
SQL Commands
Command Name | Description |
---|---|
The SELECT statement is used to select data from a database. Spice supports querying using standard SELECT statements. | |
The USE command enables you to specify the context to be used for the current query session. | |
The SHOW command can query for the existence of SQL tables with certain pattern matching. | |
The DESCRIBE TABLE command is used to provide high-level information regarding the overall column properties of an existing dataset. | |
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