Table of Contents

Search

  1. Version 6.4
  2. Version 6.3
  3. Version 6.2 Hot Fix 2
  4. Version 6.2 Hot Fix 1
  5. Version 6.2
  6. Version 6.1.1
  7. Version 6.1

Limit Rows in Query Results

Limit Rows in Query Results

Effective in version 6.3, when you connect to the Data Vault through a JDBC or an ODBC connection, you can limit the number of rows in the query results. For example, you might want to see a few rows in the results to verify that a query generates the results correctly.
To limit the number of rows in the results, add the
LIMIT
condition to the
SELECT
statement.
Use the following syntax:
<SELECT statement> LIMIT <maximum number of rows in the results>;
Example:
The following statement limits the results to the first 5 rows of the Accounts table.
SELECT col1, col2 FROM Accounts LIMIT 5;
Previously, you could use the LIMIT function only if you connected to the Data Vault through the ssasql Command Line Program.