I'm working in ArcMap 9.3 and I've never dealt with that kind of queries...
I need to Select the MAX value from column [A] for each set of records in the table which have the same value in column
For example
[A] 100 aaa 101 aaa 102 aaa 999 aaa 100 bbb 101 bbb 102 bbb 999 bbb so the selection would be record#4 (where [A]=9999 which is the biggest value of all 'aaa') and record#8 (where [A] = 999 which is the biggest of all 'bbb')
Is it possible to do that using queries and subqueries when working with databases?
Any help appreciated! Dan
أكثر...
I need to Select the MAX value from column [A] for each set of records in the table which have the same value in column
For example
[A] 100 aaa 101 aaa 102 aaa 999 aaa 100 bbb 101 bbb 102 bbb 999 bbb so the selection would be record#4 (where [A]=9999 which is the biggest value of all 'aaa') and record#8 (where [A] = 999 which is the biggest of all 'bbb')
Is it possible to do that using queries and subqueries when working with databases?
Any help appreciated! Dan
أكثر...