02 – Querying Microsoft SQL Server 2012 – Advanced SELECT Statements RG Edu 8 months ago 02 – Querying Microsoft SQL Server 2012 – Advanced SELECT Statements 2- This module describes DISTINCT, aliases, scalar functions and CASE, using JOIN and MERGE; filtering and sorting data, and NULL values.