15.00 - Example - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

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