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.

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


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


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.

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

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.

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


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.