How do you Generate sequence at the time of Display?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why teradata is used?

577


List out some of the primary characteristics of teradata.

554


What is collect statistics?

588


What are the different softwares used with their functions in teradata?

572


What do high confidence, low confidence and no confidence mean in explain plan?

589






If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

632


What is meant by a dispatcher?

563


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

588


What are the functions performed by bynet?

607


What is the use of fallback?

559


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

610


What are the frequently used data types in teradata?

599


Explain PDE.

605


What is meant by a Parsing Engine?

706


Highlight the need for Performance Tuning.

586