Timeline for Selecting limited TOP n from specific column in ArcGIS query builder?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 14, 2014 at 14:31 | history | edited | radouxju | CC BY-SA 3.0 |
added 132 characters in body
|
| Jan 14, 2014 at 14:31 | comment | added | rick | Thank you, it works now, I understand what the workaround does! So, I had to replace all [join_counts]! | |
| Jan 14, 2014 at 14:29 | comment | added | radouxju | my suggestion was to build a new field with the same ranking information but with unique value. I am not expert in SQL so you can probably write it without actually creating the new field. But on your code you only replaced one occurrence of [joint_count] : it should also be done after ORDER. | |
| Jan 14, 2014 at 14:13 | comment | added | rick | I have tried to do it as you said, but then I get an empty output. This is what used: [Join_Count] in(SELECT TOP 9 (10000*[Join_Count]+ [OBJECTID_1]) FROM spatial_join_geodat ORDER BY [Join_Count] DESC) I don't exactly know what this workaround does and why I get an empty output? | |
| Jan 14, 2014 at 11:46 | history | answered | radouxju | CC BY-SA 3.0 |