Archives of the TeradataForum

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

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

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>>