Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 26 Aug 2012 @ 11:34:25 GMT

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

Subj:   Re: What does TOP actually mean?
From:   Lenka, Dipti Prakash

Hi Mahadik,

TOP return random sampling from all AMPs.

  Then with which column(s) did it do the sort?  

It will not do sorting Unless not used "ORDER BY".

  Should it fetch me the same rows always?  

If you are using "ORDER BY" then it will return you same rows else NO.


Dipti Prakash

  <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