I have feature class (Name: V1) in personal geodatabase with columns:
Height [float] and
Id [int] representing group number
I need to do SQL query that will select eight highest 'Height' values in every group.I know that syntax below is not working but this is what I want to accomplish:
Reason I choose personal geodatabase instead of file one is that I can't create query below (I don't know why, because in personal geodatabase I can):
أكثر...
Height [float] and
Id [int] representing group number
I need to do SQL query that will select eight highest 'Height' values in every group.I know that syntax below is not working but this is what I want to accomplish:

Reason I choose personal geodatabase instead of file one is that I can't create query below (I don't know why, because in personal geodatabase I can):

أكثر...