This section contains the reference documentation for the Splice Machine SQL Clauses, in the following topics:
|CONSTRAINT||Optional clause in
|EXCEPT||Takes the distinct rows in the results from one a
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
|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.
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.|
Specifies which columns to test for equality when two tables are joined.
An optional part of a
|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.