Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Jul 2012 @ 18:57:51 GMT


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


Subj:   Re: What does TOP actually mean?
 
From:   Dave Wellman

Hi,

Without any ORDER BY clause the TOP function returns 'any' rows.

With an ORDER BY clause, I always tell students to interpret this function as returning the "First n" rows based on the specified sort criteria (i.e. the ORDER BY). This makes it easier to understand when thinking about the highest or lowest rows in the answer set base don the ORDER BY criteria.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 15 Jun 2023