select csum(1,columnname) will give you the sequence with the mentioned col

How do you Generate sequence at the time of Display?

Question Posted / yuvaevergreen

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How is MLOAD Teradata Server restarted after execution?

1339

What is meant by a node?

1074

Describe primary index in teradata?

1046

What does Amp contain and what are all the operations that it performs?

1049

How do you define Teradata?

1087

Explain teradata vs. Redshift?

1076

In Teradata, how do we Generate Sequence?

1088

What are the different methods ot loading a dimension table? A fact table etc?

1079

Write a program to show the parser component used in teradata?

1025

What is the difference between fastload and multiload?

1458

When tpump is used instead of multiload?

1142

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1122

What do you mean by teradata intellicloud?

1074

How would you load a very large file in teradata in general?

1088

What tools would you use for that?

1152