Data Manipulation (DML)MenuSelectSynopsisExampleDescriptionViewsSynopsisDescriptionInsertSynopsisDescriptionUpdateSynopsisDescriptionDeleteSynopsisDescriptionTipLogical OperatorsComparison OperatorsNoteMathematical Functions and OperatorsDescriptionMathematical OperatorsDate/Time Functions and OperatorsDate/Time FunctionsEXTRACT, date_partDescriptionCorrelated QueryCommon Table Expression (CTE)DescriptionExampleJOINExplicit syntax (ANSI SQL-92)Implicit syntax (ANSI SQL-89)Join typeExample - explicit syntaxExample - implicit syntaxAggregate FunctionsGeneral-Purpose Aggregate FunctionsGROUPING SETS, ROLLUP and CUBEWindow functionsDescriptionExample