Technical requirementsNumeric functionsMathematical functionsRounding, absolute value, and modulus functionsLogarithmic and exponential functionsLength of valuesTrigonometric functionsRadians and degreesBasic trigonometric functionsInverse trigonometric functionsHyperbolic trigonometric functionsString functionsSubstring functionsUppercase and lowercaseTrimming stringsSingle-character trimSingle-character trim for byte stringsMultiple-character trimNormalizing stringsTemporal functionsAggregating valuesSet quantifiers: DISTINCT and ALLCounting recordsNumeric aggregation functionsMAX, MIN, AVG, and SUMStandard deviationPERCENTILE_CONTPERCENTILE_DISCCollect listOther functionsTrimming a listConverting a path to a listConverting a data type with CASTExtra functionsExample: The reduce functionSummaryGet This Book’s PDF Version and Exclusive Extras