dnoeth questions

dnoeth answers

• 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
• how to find duplicate values using row_number and partition by
• How to extract rows based on column's sequence of occurences
• Teradata Alter Table Command to Modify existing column data type from varchar to char with same length