APH questions

APH answers

• Re-factor simple SQL statement with WHERE clause
• How to remove everything before a certain character in SQL Server?
• Is there a fundamental difference between INTERSECT and INNER JOIN? [duplicate]
• Selecting same column twice from a single table but with different conditions
• Efficiently query for the latest version of a record using SQL