How do you Generate sequence at the time of Display?
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
select csum(1,columnname) will give you the sequence with the mentioned column arranged in ascending order.
Is This Answer Correct ? | 2 Yes | 1 No |
What is called partitioned primary index (ppi)?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
Can you load multiple data files for same target table using fastload?
Did you write stored procedures in teradata?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
What do you mean by ttu in teradata?
Why Fload doesn’t support multiset table?
What is inner join and outer join?
What do you mean by teradata intelliflex?
How does indexing improve query performance?
What is the primary index in teradata?