on 11-14-2011 6:32 PM
I have a derived table in the universe that has fiscal year and fiscal month and I need to sort it and i used the order by
at the end of the query after by group by. The sql works when I execute it against the database through a query tool, but it
does not work in the derived table. I get an error - teradata database syntax error : that order by is not allowed in subqueries: state 42000
There are about 8 fields in my sql and I need to order by dataset by the first 2 fields only. Is there an alternate solution for this?
I don't think so. I've observed this behavior also.
I think it may be by design. They may be assuming that you will be doing you sorting in the report, not in the derived table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.