Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 20:36:55 GMT

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

Subj:   Re: SAMPLE syntax
From:   Jeremy Christiansen

  "Open interval" would eliminate all uncertainty, then?  

Uh...yeah. I don't see anything uncertain if you just recognize that the wording in the documentation is wrong. It's an open interval...case closed. (Open intervals are defined as all numbers between 2 endpoints except for the endpoints themselves.)

Proof: You can't get 0% of the rows nor can you get 100% (those are the 2 endpoints). You can "cheat" by saying "sel * from x sample 0", but then you are no longer using the "fractional_description" syntax but rather the "count_description" syntax. Note that "sel * from x sample 0.0" returns an error. The only "buggy" thing about this is the fact that "sel * from x sample 1.0" is parsed as "count_description" syntax instead of "fractional_description" syntax. Anyway, who cares. The guy can't get what he wants directly. Nuff said.

  <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: 23 Jun 2019