Query max numeric value

635
3
Jump to solution
03-20-2018 09:48 AM
WalterDziuba1
New Contributor III

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

0 Kudos
1 Solution

Accepted Solutions
JoshuaBixby
MVP Esteemed Contributor

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

View solution in original post

3 Replies
JoshuaBixby
MVP Esteemed Contributor

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

WalterDziuba1
New Contributor III

Joshua,

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

Walter

0 Kudos
WalterDziuba1
New Contributor III

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

0 Kudos