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

Joerg,

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


     SELECT
        "THE_WEEK_V"."WeekID"      "WeekID" ,
        "THE_WEEK_V"."WeekCD"    "WeekCD" ,
        "THE_WEEK_V"."WeekDesc" "WeekDesc"
     FROM "RD_VIEWS"."THE_WEEK_V" "THE_WEEK_V"
     ORDER BY
        "WeekID"


     
  <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: 27 Dec 2016