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
condition to the
Use the following syntax:
<SELECT statement> LIMIT <maximum number of rows in the results>;
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.