How do you Generate sequence at the time of Display?

Answers were Sorted based on User's Feedback



How do you Generate sequence at the time of Display?..

Answer / vinay

By Using CSUM

Is This Answer Correct ?    10 Yes 0 No

How do you Generate sequence at the time of Display?..

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

Post New Answer

More Teradata Interview Questions

What is called partitioned primary index (ppi)?

0 Answers  


What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,


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?

1 Answers  


Did you write stored procedures in teradata?

0 Answers  






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.

2 Answers   IBM,


What do you mean by ttu in teradata?

0 Answers  


Why Fload doesn’t support multiset table?

9 Answers  


What is inner join and outer join?

0 Answers  


What do you mean by teradata intelliflex?

0 Answers  


How does indexing improve query performance?

4 Answers   Satyam,


What is the primary index in teradata?

0 Answers  


Categories