I would like to know that...
Does teradata supports temp table while connecting to database using direct query?
So my issue is I have query (for teradata db) with temp table logic and get the selected rows from final result of temp table.
Your advise or suggestion will help a lot.
You can edit the table to get the rows you want by this way.
Does that make sense? If so, kindly mark the answer as solution to close the case.