 |
 |
Archives of the TeradataForum
Message Posted: Thu, 06 Jan 2005 @ 13:32:12 GMT
Subj: | | Re: Order by clause |
|
From: | | Victor Sokovin |
| select * from t1 order by 2+1 --------------- assumes all rows to have value 3 and sorts on that basis. | |
If it sorts on the third column, that would be what I expect it to do, for what that's worth.
I don't know what you try to achieve but there are a few variations on the "order by expression" theme in the following thread:
www.teradataforum.com/teradata/20041007_213251.htm.
Perhaps they might help.
Regards,
Victor
| |