Paul Maxwell questions

Paul Maxwell answers

• latest rate and sum of quantity from mysql table
• Normalize a row of data in a query - Turn one row into many
• Sort Month Name in SQL Query
• SQL Pivot Table On A Common Table Expression
• Using count my tuples are coming out as 1's when a 0 should be present?
• A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause in UPDATE
• a FIFO query in SQL Server
• Columns in rows in big datasets (PostgreSQL) --Transponse?
• how to separated One column to two with cases
• MySQL Sum values by date, compare this year to last year