GMB questions

GMB answers

• How to loop through data and compare previous batch to current batch in SQL Server?
• Implement Recursive CTE for Hierarchical Query to MariaDB
• MySQL - Recursively list all parents and ancestors of all items in table
• Postgresql "column must appear in the GROUP BY clause or be used in an aggregate function" and unique field
• Perl Regex expression to capture string between start and end of line (with end of line having a space with character)
• LEFT JOIN match. If no match, need to match on most recent date
• SQL Server Pivot One Column and Keep Other Columns
• With Postgres, how can I use UPDATE to insert a new jsonb value if NULL, or amend the json if a value already exists?
• Types of Wildcards in MySql
• Postgres get all elements where value matches from jsonb array