I would create an event layer in ArcMap selecting values from a table with a sql query.
In ArcMap, I can open the table > Table Options > Select By Attributes.
Use a similar expression
FIELD_NAME = (SELECT MAX(FIELD_NAME) FROM TABLE_NAME)
Easting = (SELECT MAX(Easting) FROM RealPosition)
The problem is that I used a "join" where a "relate" was needed, so it didn't work.
I have another problem:
I want select max value between rows that have an attribute equal to a value(for example Unit = 'TAB1')Is it possible to do "sequential sql queries "?
I think I understand the question, but an example using some sample data would be most helpful. If you want to select the maximum value in a group:
It can be possible, but it depends on the back-end data source because SQL support is based on the data source.