0 - 4 of 4 tags for ORDER BY

I am trying to get the top 20% of a larger grouping of items;
For example

At my workplace I can't create permanent tables, so I have been creating volatible tables as middle steps for joins later on very large data set. 

Hi All,


Order by Behavior is different in DB2 and Teradata 


I already tried adding Case specific which doesn’t work for my project related data .


Here is the main query modified (table-name etc for security reasons and its output Demo Data but similar to main one )

Recently our TD system got upgraded to Teradata 14.10.0206 from Teradata 13.11. After the upgradation, I can see an unusual behavior.
the script never used to fail previously, but now its failing after the upgradation.
Below is the scenario: