SELECT

The FROM Clause

The FROM clause specifies which table(s) data will be queried from. If multiple tables are queried, the subsequent table(s) that follow the first table will use a JOIN clause. See JOIN and Subqueries for details about join syntax.

The WHERE Clause

The WHERE clause specifies the conditions that must be met for a row to be included in the result set.

The GROUP BY and HAVING Clauses

The GROUP BY clause groups rows together that have the same values for columns listed in the SELECT clause. The GROUP BY clause must be used for columns not aggregated. See the Aggregate Functions section for more information on how to use the GROUP BY clause in queries that contain aggregate functions.

The HAVING clause is used to filter the results of queries that use a GROUP BY clause. The HAVING clause can refer to grouped and ungrouped columns.

The ORDER BY Clause

The ORDER BY clause sorts the result set of a query based on one or more columns. Either ascending (ASC) or descending (DESC) can be specified. By default, if you don't specify ASC or DESC, the sort will be in ascending order.

The LIMIT Clause

The LIMIT clause is used to restrict the number of rows returned in the result set to the number specified.

Related Information

SQL Functions List - this is a list of all the SQL functions SingleStore current used. SQL Functions can be used in SELECT statements.