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

2 Answers
8437 Views
Infosys, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe the between keyword in teradata?

1040

What is the difference between union and union all in teradata?

1128

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1043

What are the functions of a Parser?

1113

What is stored procedure in teradata?

1030

Explain teradata architecture?

1093

What are the available primary index types?

1222

Explain vproc in teradata?

1003

What are the uses of client software involved in teradata?

984

Difference between star and snowflake schemas?

1154

What are the different functions performed in development phase?

1080

Explain teradata architecture in detail with a diagram.

1113

What is the use of virtual processor connectivity in teradata?

1032

Can we collect statistics on multiple columns?

1067

Explain parsing engine in teradata?

1092