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,

Mike



     
  <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