Clauses

This section contains the reference documentation for the Splice Machine SQL Clauses, in the following topics:

Clause Description
CONSTRAINT Optional clause in ALTER TABLE statements that specifies a rule to which the data must conform.
EXCEPT Takes the distinct rows in the results from one a SELECT statement.
FROM

A clause in a SelectExpressionthat specifies the tables from which the other clauses of the query can access columns for use in expressions.

GROUP BY

Part of a SelectExpression that groups a result into subsets that have matching values for one or more columns.

HAVING

Restricts the results of a GROUP BY clause in a SelectExpression.

LIMIT n Limits the number of results returned by a query.
OVER Used in window functions to define the window on which the function operates.
ORDER BY

Allows you to specify the order in which rows appear in the result set.

RESULT OFFSET
 and FETCH FIRST
Provide a way to skip the N first rows in a result set before starting to return any rows and/or to limit the number of rows returned in the result set.
TOP n Limits the number of results returned by a query.
UNION Combines the result sets from two queries into a single table that contains all matching rows.
USING

Specifies which columns to test for equality when two tables are joined.

WHERE

An optional part of a UPDATE statement that lets you select rows based on a Boolean expression.

WITH Allows you to name subqueries to make your queries more readable and/or to improve efficency.



For access to the source code for the Community Edition of Splice Machine, visit our open source GitHub repository.