How do you Generate sequence at the time of Display?

Answers were Sorted based on User's Feedback



How do you Generate sequence at the time of Display?..

Answer / vinay

By Using CSUM

Is This Answer Correct ?    10 Yes 0 No

How do you Generate sequence at the time of Display?..

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

More Teradata Interview Questions

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,


Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,


How does hashing happens in teradata?

0 Answers  


How is Teradata in current market?

4 Answers  


Highlight the advantages of PPI(Partition Primary Index).

0 Answers  


How to view every column and the columns contained in indexes in teradata?

0 Answers  


What is the use of virtual processor connectivity in teradata?

0 Answers  


suppose one Cylinder split data blocks are moved from where?

1 Answers  


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

0 Answers  


What is smp and mpp platforms?

0 Answers  


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  


How many types of index are present in teradata?

1 Answers  


Categories