How do you Generate sequence at the time of Display?

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

What are the various indexes in teradata?

561


How will you solve the problem that occurs during update?

577


In Teradata, how do we Generate Sequence?

601


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

587


Explain the term 'tables' related to relational database management system?

590






Comment whether bottleneck is an error or not.

615


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

653


What are the available join types in teradata?

594


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

585


What is a sparse index?

624


What is a node in teradata?

577


What interface is used to connect to windows based applications?

580


Syntax for case when statement?

606


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

553


What is the opening step in basic teradata query script?

592