Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 28 Jan 2008 @ 11:00:24 GMT

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

Subj:   Re: Sorting of a Select
From:   Christopher Stephens


For all of our benefit, can you tell us which frontend tool refuses to generate an ORDER BY clause when querying Teradata tables or views? Is it custom built, or is it something we may have heard of / may need to work with in the future?

Also, do you know of any database platforms that do allow views to be created with an ORDER BY clause? Does SQL Server, Oracle, DB2, etc. allow this or something?

- Chris

        "THE_WEEK_V"."WeekID"      "WeekID" ,
        "THE_WEEK_V"."WeekCD"    "WeekCD" ,
        "THE_WEEK_V"."WeekDesc" "WeekDesc"

  <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