How do you Generate Sequence in Teradata?
Answers were Sorted based on User's Feedback
Answer / vinay
By Using Identity Column.
/*I am Teradata working professional and Faculty with 7+
yrs of exp posting for knowledge transfer to students.You
can reach me on teradatavinay@yahoo.com if more
clarification needed./*
Is This Answer Correct ? | 14 Yes | 4 No |
Answer / kk
1-for storing purpose using identity
2-for display purpose using csum
Is This Answer Correct ? | 8 Yes | 6 No |
Answer / sridhar
using identity we can generate sequence
syntax:
generated always/by default as identity (start with <value> increment by <value> min<value> max<value> no cycle)..
Is This Answer Correct ? | 0 Yes | 1 No |
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
if collect stats but it show low confidence why?
What are the frequently used data types in teradata?
in teradata level primary in table level allows duplicates why?
Explain the parallel data extension in teradata?
What is the purpose of using case expression in teradata?
What is bteq utility in teradata?
how can i answer for question like teradat architecture in interveiw
Explain teradata utilities. What is multiload, fast load, tpump?
What are the updated features of teradata?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?