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:

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.