esriSQLFunctionName Constants

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

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.

You can no longer sign into this site. Go to your ArcGIS portal or the ArcGIS Location Platform dashboard to perform management tasks.

Your ArcGIS portal

Create, manage, and access API keys and OAuth 2.0 developer credentials, hosted layers, and data services.

Your ArcGIS Location Platform dashboard

Manage billing, monitor service usage, and access additional resources.

Learn more about these changes in the What's new in Esri Developers June 2024 blog post.

Close