Table of Contents

Search

  1. Version 6.4.4
  2. Version 6.4.3 HotFix 1
  3. Version 6.4.3
  4. Version 6.4 HotFix 2
  5. Version 6.4 HotFix 1
  6. Version 6.4
  7. Version 6.3
  8. Version 6.2 Hot Fix 2
  9. Version 6.2 Hot Fix 1
  10. Version 6.2
  11. Version 6.1.1
  12. Version 6.1

Release Guide

Release Guide

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.