 |
 |
Archives of the TeradataForum
Message Posted: Tue, 25 Mar 2008 @ 13:21:50 GMT
| Subj: | | Re: Alias field into table |
| |
| From: | | Victor Sokovin |
> select field1 as "month"
> from table a
| | I need the alias "month" to be a variable, every end of month I want to run a query having a field with the name of the previous month, I
wonder if it is possible. | |
I don't think it is possible in pure SQL. You'll probably have to write a script which would build the SQL statement text dynamically before it
is sent to the database.
Victor
| |
