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

What are default access rights in teradata? What explicit right can be given to a user?

1056

what are the day to day activities of teradata DBA ?

5755

Discuss the advantages of using partitioned primary index in a query?

905

How do you determine the number of sessions?

1007

how can we analyze the locks ?

2058

How do you create tables? Exact syntax, and create profiles, users in teradata?

973

Explain fallback in teradata?

984

How will you solve the problem that occurs during update?

986

What interface is used to connect to windows based applications?

1036

Explain some differences between mpp and smp?

1035

What is teradata? What are some primary characteristics of teradata?

927

What is teradata and why it is used?

1011

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1901

How can we check the version of Teradata that we are using currently?

1012

What is meant by Teradata Gateway?

1002