Chapter 6: DML statements

Table of Contents

EXECUTE PROCEDURE

SELECT

Aggregate functions: Extended functionality

Ambiguous JOIN statements rejected

[AS] before relation alias

FIRST and SKIP

GROUP BY UDF

GROUP BY internal function, column position, and CASE

HAVING: Stricter rules

ORDER BY: Expressions and NULLs placement

ORDER BY: Stricter rules with aggregate statements

WITH LOCK