SqlZim questions

SqlZim answers

• WHERE and WHERE NOT in SELECT
• SQL Select column with maximum value in another column
• Count how many orders were shared between customers
• How to rename column before unpivot? SQL Server
• Get the latest value for each column
• Query on large table using DateTime WHERE clause
• How can I add an autoincrementing ID field to a table in SQL-SERVER starting from X
• MS sql server 2014 select dynamic pivot with lag using last known value for the pivoted column
• MERGE with DELETE on target with partial match on source?
• SQL Update Join Multiple Tables (if field exists)