How do you Generate sequence at the time of Display?

Question Posted / vinay

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

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

Steps to create a data model?

0 Answers

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

0 Answers

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers IBM,

How to relege locks in fastload and multiload? example?

4 Answers IBM,

How do you define Teradata?

0 Answers

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers IBM,

How is MLOAD Client System restarted after execution?

0 Answers

What is primary index and secondary index?

0 Answers

what is DYNAMIC SQL in TD?