 |
 |
Archives of the TeradataForum
Message Posted: Sat, 05 Sep 2009 @ 08:47:36 GMT
| 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 :-)
Dieter
| |
