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 |