On this page
SELECT statement is used to retrieve data from a table.
SELECT clause specifies the columns to be retrieved from the table(s).
SELECT page gives details of the syntax for these options.
The following clauses make up the basic parts of a
FROM clause in most cases.
FROM clause specifies which table(s) data will be queried from.
WHERE clause specifies the conditions that must be met for a row to be included in the result set.
GROUP BY clause groups rows together that have the same values for columns listed in the
GROUP BY clause in queries that contain aggregate functions.
HAVING clause is used to filter the results of queries that use a
GROUP BY clause.
HAVING clause can refer to grouped and ungrouped columns.
ORDER BY clause sorts the result set of a query based on one or more columns.
ASC) or descending (
DESC) can be specified.
DESC, the sort will be in ascending order.
LIMIT clause is used to restrict the number of rows returned in the result set to the number specified.
SQL Functions List - this is a list of all the SQL functions SingleStore current used.
Last modified: June 22, 2023