does anybody know what is the syntax of arcgis sql expression as i am finding difficult to understand and implemention .it will be much helpful.Thank you in advance

[AnupamSharma]

i know the sql language,but i am unfamiliar with arcgis sql expression/syntax  

[RobertScheitlin__GISP]

In ArcGIS you only have access to the WHERE clause of a SQL statement. Most SQL is supported as long as it is only the WHERE clause.

http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm

https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm

[AnupamSharma]

https://developers.arcgis.com/javascript/latest/sample-code/layers-scenelayerview-query-stats/index....

in the above code why "when"  used also what is onStatisticField, outStatisticFieldName,statisticType it will be very much helpful if you explain.Thank you 

[RobertScheitlin__GISP]

Anupan,

  In that code snippit the when is part of an Arcade expression.

"CASE WHEN (yearCompleted >= '1975' AND yearCompleted <= '1999') THEN 1 ELSE 0 END",

https://developers.arcgis.com/javascript/3/jshelp/arcade.html