Query max numeric value

[WalterDziuba1]

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

[JoshuaBixby · Accepted solution]

Some ideas here that I think will work:  https://community.esri.com/thread/177516 

[WalterDziuba1]

Joshua,

That's perfect. Appreciate your help on this topic.

Walter

[WalterDziuba1]

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?

Walter