AnsweredAssumed Answered

Query max numeric value

Question asked by WDziuba on Mar 20, 2018
Latest reply on Mar 23, 2018 by WDziuba

Afternoon,

 

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?

 

Walter

Outcomes