Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 05 Sep 2009 @ 08:47:36 GMT

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

Subj:   Re: INSERT into table with select Order by clause
From:   Dieter Noeth

Glenn David McCall wrote:

  All of the other postings are correct not only for Teradata but for set theory as well which Relational Databases are (or should be) based upon.  

          > Replace view pview.target_table
          > As
          > Select x,y,z
          > From pdata.target_table
          > Order by z
          > ;

Hi Glenn,

this will result in a syntax error.

And it violates set theory, too. Even Standard SQL doesn't allow it, and Standard SQL is far away from relational theory :-)


  <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