Example - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Product
Interactive Teradata Query Facility
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2451
Product Category
Teradata Tools and Utilities

Example

To limit a selected result to 100 records, the user could specify the SET RETLIMIT command as follows:

SET RETLIMIT 100

To return to standard operation, the user could specify the SET RETLIMIT command as follows:

SET RETLIMIT 0