Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 26 Jan 2008 @ 11:19:14 GMT

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

Subj:   Re: Sorting of a Select
From:   Christian Schiefer, makeITdone


this works as defined in SQL. ( There is no order defined "a priori" if you work with sets )

If the problem is the additional single line "order by MonthID", then there are 3 options:

1.) just add it

2.) if option 1 is not possible: Switch to a more "flexible" front end tool

3.) Join one of the standardisation committees and place your idea of "ordered views". Good Luck!



  <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: 28 Jun 2020