SQL for Analytics Developer Guide

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
Introducing SQL for CRM Analytics
Quick Start: Run Your First Query
SQL vs SAQL
SQL Statements
SELECT Clause
FROM Clause
WHERE Clause
Boolean Expressions in SELECT Clause
GROUP BY Clause
GROUP BY ROLLUP
GROUPING()
HAVING Clause
ORDER BY Clause
LIKE Clause
BETWEEN Operator
LIMIT Clause
FETCH Clause
OFFSET Clause
CASE Statements
COALESCE()
NULLIF()
UNION Operator
Subquery
Window Functions
Date Functions
Aggregate Functions
Math Functions
String Functions and Operators
Release Notes
PDF

LIMIT Clause

The LIMIT clause specifies the maximum number of rows to return. If no LIMIT clause is specified, then SQL returns all rows.

LIMIT follows the syntax LIMIT {count}.

When working with two or more columns, make sure to use LIMIT with an ORDER BY clause, so that your results are returned in a specified order. Otherwise, results return in an order you may not want. ORDER BY is optional for working with a single column.

Important

Here’s an example.

SELECT City
FROM "Superstore"
ORDER BY City
LIMIT 5;

This query returns the cities in the first three rows of the dataset.

City
Aberdeen
Abilene
Akron
Akron
Akron