selecting maximum value of an attribute table to create a layer

Question

Hi,

I would create an event layer  in ArcMap selecting values from a table  with a sql query.

In particular I would like to select the row with the maximum value of an attribute, so I thinked a sql query as:RealPosition.Easting = ( SELECT MAX ( RealPosition.Easting ) FROM RealPosition )where RealPosition is the table and Easting is the attributo but the select tool but it says an invalid sql expression was used. How can I solve?Thanks.

SalvoA · Answer

Yes, your example is correct.

what kind of database should I use?

Thanks.

JoshuaBixby · Answer

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:

IDValueA5A2A10B3C4C6

It can be possible, but it depends on the back-end data source because SQL support is based on the data source.

SalvoA · Answer

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.