dnoeth questions

dnoeth answers

• Last_value over partition by
• Connected Components
• Insert with multiple selects
• Impala: all DISTINCT aggregate functions need to have the same set of parameters
• Converting an unknown six digit date format, possibly some variant of Julian
• Teradata: how can I get the primary key and foreign key definition of a table?
• Split String Teradata SQL
• SQL Challenge/Puzzle: Given a stack trace - How to find the top element at each point in time?
• Get column type using teradata system tables
• Teradata CASE and HAVING COUNT