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

How to load specific no.of records using bteq, or fastload,or multiload

1546


What are the various etl tools in the market?

862


Explain fallback in teradata?

837


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3319


Explain the meaning of Amp?

796


During the Display time, how is the sequence generated by Teradata?

833


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

873


Highlight a few of the important components of Teradata?

820


Write a program to show the parser component used in teradata?

770


How will you solve the problem that occurs during update?

832


What are the scenarios in which full table scans occurs?

786


If a Node is busy what are the steps you can take to avoid ?

2141


Name the five phases that come under MultiLoad Utility.

797


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

832


What is the use of stored procedures in teradata?

804