How can I place a limit on the number of rows returned by a query?
Article ID: KB0079992
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | v7.0.0 and higher |
Description
How can I place a limit on the number of rows returned by a query?
Issue/Introduction
How can I place a limit on the number of rows returned by a query?
Resolution
You can use TOP or the MAX_ROWS_LIMIT query hint to limit the number of rows that TDV returns. The following examples demonstrate how to limit the number of rows to 2.
SELECT TOP 2 domain_name FROM /services/databases/system/ALL_DOMAINS;
SELECT {option MAX_ROWS_LIMIT=2} domain_name FROM /services/databases/system/ALL_DOMAINS;
Feedback
Yes
No
Powered by
