 |
 |
Archives of the TeradataForum
Message Posted: Thu, 08 Jan 2004 @ 15:29:34 GMT
| Subj: | | Re: The ORDER BY clause |
| |
| From: | | Dieter Noeth |
Narayan Murthy wrote:
| | Given you had 4 columns in a table say "T1" and given a query | |
| | SELECT * FROM T1 order by 1,2,3,4; | |
| | Can the above query contain the following values in the ORDER BY clause | |
| | d. repeating column specification i.e. ORDER BY 1,2,1 | |
| | Case a. & d. give no error currently, but do they make sense, if so what. | |
You can do lots of stupid things in SQL ...
| | Case b. & c. give error (this is correct - isn't it) | |
... but not that stupid ;-)
Dieter
| |
