How do you Generate sequence at the time of Display?
Answers were Sorted based on User's Feedback
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 |
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 ?
How does hashing happens in teradata?
How is Teradata in current market?
Highlight the advantages of PPI(Partition Primary Index).
How to view every column and the columns contained in indexes in teradata?
What is the use of virtual processor connectivity in teradata?
suppose one Cylinder split data blocks are moved from where?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is smp and mpp platforms?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How many types of index are present in teradata?