Rob Paller questions

Rob Paller answers

• Why doesn't Teradata identity column increment by 1?
• Compare 3 Consecutive rows in a table
• RowID in Teradata
• Unnecessary IO and Product Join Indicators
• Count the number of 7AM or 7PM occurrences between two datetimes
• Teradata: Is there a way to generate DDL from a view or select statement?
• Create table but Drop it if the table exists already
• Connecting Java and Teradata: The UserId, Password or Account is invalid
• Teradata equivalent for lead and lag function of oracle
• I need to split string in select statement and insert to table