Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 15 May 2002 @ 17:28:18 GMT

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

Subj:   Re: Limit rows returned from a query
From:   Yen Tsai


Under the Queryman tools, options tab, you can set the number of rows to return to Queryman to 50,000. Queryman will pop up a screen to ask you if you want to continue once it reach the limit you have set for the number of rows returned.

It will still generate the entire answer set on the database since you seem to indicate that you need to sort the entire answer set for your query rather than just have a sample of 50,000 rows.

Yen T. Tsai
Technical Industry Consultant
Travel and Transportation
Teradata A Division of NCR

  <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: 28 Jun 2020