Paul Maxwell questions

Paul Maxwell answers

• 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
• Complex MySQL sort
• Impala SQL build columns based on row data and populating columns with additional row data
• Mysql query select every user per date latest record