SQL Functions.
| Constant | Value | Description |
|---|---|---|
| esriSQL_​MIN | 1 | SQL MIN. |
| esriSQL_​MAX | 2 | SQL MAX. |
| esriSQL_​COUNT | 3 | SQL COUNT. |
| esriSQL_​SUM | 4 | SQL SUM. |
| esriSQL_​AVG | 5 | SQL AVG. |
| esriSQL_​VAR | 6 | SQL VAR. |
| esriSQL_​STDDEV | 7 | SQL Standard Deviation. |
| esriSQL_​CONCAT | 8 | SQL CONCAT. |
| esriSQL_​LEADING | 9 | SQL LEADING. |
| esriSQL_​LOWER | 10 | SQL LOWER. |
| esriSQL_​TRAILING | 11 | SQL TRAILING. |
| esriSQL_​SUBSTRING | 12 | SQL SUBSTRING. |
| esriSQL_​SUBSTRINGBYTES | 13 | SQL SUBSTRING Bytes. |
| esriSQL_​UPPER | 14 | SQL UPPER. |
| esriSQL_​ASCII | 15 | SQL ASCII. |
| esriSQL_​CHAR | 16 | SQL CHAR. |
| esriSQL_​SOUNDEX | 17 | SQL SOUNDEX. |
| esriSQL_​TRANSLATE | 18 | SQL TRANSLATE. |
| esriSQL_​TRIM | 19 | SQL TRIM. |
| esriSQL_​ABS | 20 | SQL ABS. |
| esriSQL_​ACOS | 21 | SQL ACOS. |
| esriSQL_​ASIN | 22 | SQL ASIN. |
| esriSQL_​ATAN | 23 | SQL ATAN. |
| esriSQL_​CEILING | 24 | SQL CEILING. |
| esriSQL_​COS | 25 | SQL COS. |
| esriSQL_​FLOOR | 26 | SQL FLOOR. |
| esriSQL_​LOG | 27 | SQL LOG. |
| esriSQL_​LN | 28 | SQL LN. |
| esriSQL_​MOD | 29 | SQL MOD. |
| esriSQL_​SIGN | 30 | SQL SIGN. |
| esriSQL_​SIN | 31 | SQL SIN. |
| esriSQL_​TAN | 32 | SQL TAN. |
| esriSQL_​LOG10 | 33 | SQL LOG10. |
| esriSQL_​POWER | 34 | SQL POWER. |
| esriSQL_​ROUND | 35 | SQL ROUND. |
| esriSQL_​TRUNCATE | 36 | SQL TRUNCATE. |
| esriSQL_​SINH | 37 | SQL SINH. |
| esriSQL_​COSH | 38 | SQL COSH. |
| esriSQL_​TANH | 39 | SQL TANH. |
| esriSQL_​HEX | 40 | SQL HEX. |
| esriSQL_​EXTRACT | 41 | SQL EXTRACT. |
| esriSQL_​BITLENGTH | 42 | SQL BITLENGTH. |
| esriSQL_​CHARLENGTH | 43 | SQL CHARLENGTH. |
| esriSQL_​OCTETLENGTH | 44 | SQL OCTETLENGTH. |
| esriSQL_​POSITION | 45 | SQL POSITION. |
| esriSQL_​CURRENTDATE | 46 | SQL CURRENTDATE. |
| esriSQL_​CURRENTTIME | 47 | SQL CURRENTTIME. |
| esriSQL_​CURRENTUSER | 48 | SQL CURRENTUSER. |
| esriSQL_​COALESCE | 49 | SQL COALESCE. |
| esriSQL_​CONVERT | 50 | SQL CONVERT. |
| esriSQL_​CAST | 51 | SQL CAST. |
| esriSQL_​CURRENTTIMESTAMP | 52 | SQL CURRENTTIMESTAMP. |
| esriSQL_​NULLIF | 53 | SQL NULLIF. |
| esriSQL_​VAR_​SAMP | 54 | SQL VAR_​SAMP. |
| esriSQL_​VAR_​POP | 55 | SQL VAR_​POP. |
| esriSQL_​STDDEV_​SAMP | 56 | SQL STDDEV_​SAMP. |
| esriSQL_​STDDEV_​POP | 57 | SQL STDDEV_​POP. |
| esriSQL_​PERCENTILE_​CONT | 58 | SQL Percentile Continuous. |
| esriSQL_​PERCENTILE_​DISC | 59 | SQL Percentile Discrete. |
| esriSQL_​ST_​LENGTH | 60 | |
| esriSQL_​ST_​PERIMETER | 61 | |
| esriSQL_​ST_​AREA | 62 | |
| esriSQL_​ST_​NUMPOINTS | 63 | |
| esriSQL_​ST_​NUMGEOMETRIES | 64 | |
| esriSQL_​ST_​XMIN | 65 | |
| esriSQL_​ST_​XMAX | 66 | |
| esriSQL_​ST_​YMIN | 67 | |
| esriSQL_​ST_​YMAX | 68 | |
| esriSQL_​ST_​ZMIN | 69 | |
| esriSQL_​ST_​ZMAX | 70 | |
| esriSQL_​ST_​MMIN | 71 | |
| esriSQL_​ST_​MMAX | 72 | |
| esriSQL_​CUME_​DIST | 73 | |
| esriSQL_​FIRST_​VALUE | 74 | |
| esriSQL_​LAST_​VALUE | 75 | |
| esriSQL_​LEAD | 76 | |
| esriSQL_​LAG | 77 | |
| esriSQL_​PERCENT_​RANK | 78 | |
| esriSQL_​RANK | 79 | |
| esriSQL_​NTILE | 80 | |
| esriSQL_​DENSE_​RANK | 81 | |
| esriSQL_​ROW_​NUMBER | 82 | |
| esriSQL_​REGR_​SLOPE | 83 | |
| esriSQL_​REGR_​INTERCEPT | 84 | |
| esriSQL_​REGR_​R2 | 85 |