Data Manipulation (DML) Select SynopsisExampleDescription Views SynopsisDescription Insert SynopsisDescription Update SynopsisDescription Delete SynopsisDescriptionTip Logical Operators Comparison Operators Note Mathematical Functions and Operators DescriptionMathematical OperatorsDate/Time Functions and OperatorsDate/Time Functions EXTRACT, date_part Description Correlated Query Common Table Expression (CTE) DescriptionExample JOIN Explicit syntax (ANSI SQL-92)Implicit syntax (ANSI SQL-89)Join typeExample - explicit syntaxExample - implicit syntax Aggregate Functions General-Purpose Aggregate Functions GROUPING SETS, ROLLUP and CUBE Window functions DescriptionExample