How do you Generate sequence at the time of Display?

Question Posted / vinay

2 Answers
8256 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

can I use “drop” statement in the utility “fload”?

2 Answers Accenture, CTS, NTT Data,

wt r before journal& after journel.....in teradata

4 Answers

How do you set the session mode parameters in bteq?

0 Answers

what is differences between Fastload and Multiload as per DBA aspect ?

1 Answers Wipro,

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

4 Answers Teradata,

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

5 Answers IBM,

Highlight all the modes that are present under Confidence Level.

0 Answers

What is teradata? What are some primary characteristics of teradata?

0 Answers

What are the string manipulation operators and functions associated with teradata?

0 Answers

Explain Teradata performance tuning and optimization?

0 Answers

Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers

what is referential constraints?how do you implement RI in teradata?

2 Answers Wipro,

For more Teradata Interview Questions Click Here