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?