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 is difference between user and database in teradata?

853

Explain the term 'foreign key' related to relational database management system?

760

What is partitioned primary index (ppi)?

815

What are the available primary index types in teradata.

792

What are the multiload utility limitations?

803

Describe primary index in teradata?

781

Highlight a few of the important components of Teradata?

797

What are the design features involved in teradata?

768

What's the difference between timestamp (0) and timestamp (6)?

918

How many sessions of MAX is PE capable of handling at a particular time?

816

What is meant by a Clique?

815

List out all forms of LOCKS that are available in Teradata.

752

Explain how spool space is used.

848

In BTEQ, how are the session-mode parameters being set?

913

What are some primary characteristics of teradata?

755