Sign inTry Free

SELECT

On this page

The SELECT statement is used to retrieve data from a table. See the SELECT page for more details such as syntax, remarks, and examples.

The SELECT clause specifies the columns to be retrieved from the table(s). All columns can be specified. Distinct (not repeated) values for a column can also be specified. The SELECT page gives details of the syntax for these options.

The following clauses make up the basic parts of a SELECT statement. The clauses are optional except for the FROM clause in most cases.

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.

Last modified: June 22, 2023

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK