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 |
Which Teradata concept allows more than one model generation?
How many tables can you join in v2r5?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
How do you determine the number of sessions?
What are the components used in smp and massively parallel processing (mpp) machines?
Why do you get spool space errors? How do trouble-shoot them?
What are the available primary index types in teradata.
Explain the term 'foreign key' related to relational database management system?
how do you manage the production space. what are the proactive methods you can take ?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
What do you mean by teradata sql assistant?
Highlight all the modes that are present under Confidence Level.