Hi,
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)
Try
Easting = (SELECT MAX(Easting) FROM RealPosition)
Thanks for your replay.It's work for a simple table, but I have a table joined with another.Could this be the problem?
Oh!
A similar expression (to your original expression) works for me. My tables are stored in a File Geodatabase.
Thanks.
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 "?
Thanks.
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:
ID | Value |
A | 5 |
A | 2 |
A | 10 |
B | 3 |
C | 4 |
C | 6 |
It can be possible, but it depends on the back-end data source because SQL support is based on the data source.
Yes, your example is correct.
what kind of database should I use?
Thanks.