I need to query out the max(result_numeric) value from my feature service.
Result_Numeric is of type (numeric(38,8)
Since only where clauses can be used, I'm trying this sql statement:
where requestor = 'Jack'
and RESULT_NUMERIC = (
select MAX(RESULT_NUMERIC) AS MAX_RESULT from My_Feature_Service
where requestor = 'Jack')
Can anyone add some assistance?
Solved! Go to Solution.
Now that I am able to retrieve the max numeric value from my feature service, it seems that the geometry is not being returned, even though return geometry is set to true.
Is this working as designed, or am I missing something?