How do you Generate sequence at the time of Display?

Question Posted / vinay

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

More Teradata Interview Questions

how can i answer for question like teradat architecture in interveiw

In Teradata, what is the significance of UPSERT command?

What is upsert statement in teradata?

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

On which column will you take primary index???

can we join volatile table with general table an global temporary table with general table ?

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

what are the roles and responsibilities of teradata DBA ?

Highlight a few of the advantages that ETL tools have over Teradata.

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

Give a justifiable reason why Multi-load supports NUSI instead of USI.

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

For more Teradata Interview Questions Click Here