Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 10 Jan 2001 @ 18:09:44 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Limited Select
From:   Michael Larkins

Hi Susan:

There are a couple of ways to request only 10 rows:

1. In V2R3, you can add SAMPLE 10 to your SELECT and it will randomly select only 10 rows.

2. If using BTEQ: .set retlimit 10 - returns only first 10 rows

3. If using Queryman: Tools=>Options - Answer Set, change the Maximum number of answer set rows to return to 10

Hope this helps,


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016