dnoeth questions

dnoeth answers

• Numeric Overflow in Recursive Query : Teradata
• Find the movies with the highest average rating using SQL max()
• How to find duplicates from multiple tables at once in Teradata?
• How to convert an YYYY-MM-DD date to YYYY-MM date
• Join Query Results
• Latest instance of sql row without self join
• Limiting SQL results based on JOIN ON parameter(s) or WHERE parameter(s)
• Obtaining multiple percentiles (percentile_cont equivalent) in one pass within Teradata
• Getting the latest status and date for each ID
• Calculate previous week data in Teradata