idea Use Select by Attributes to select greatest n records (FGDB) in ArcGIS Pro Ideas

Use Select by Attributes to select greatest n records (FGDB)

Bud — Fri, 09 Feb 2024 18:12:23 GMT

ArcGIS Pro 3.2.1; file geodatabase

As far as I know, there isn’t a way to use Select By Attributes to select the top n records of a FGDB FC, such as select the 4 cities with the largest POPULATION (no ties).

See:

Select the records with the highest values in a particular field
https://community.esri.com/t5/arcgis-pro-questions/arcgis-3-0-2-what-tool-can-select-the-records-with/m-p/1370898#M77491
Select the 3 features that have the largest attribute value

Re: FGDB SQL Expression — Select greatest n records

Bud — Wed, 17 Jan 2024 18:21:25 GMT

I suppose this idea might be a duplicate of my other idea: SQL LIMIT clause in FGDB SQL

And this idea is related too: ROW_NUMBER function in FGDB SQL

In those ideas, I wanted to make it clear that I want those specific functions/clauses in FGDB SQL. They would help with the current idea above, as well as many other use cases.

Re: Use Select by Attributes to select greatest n records (FGDB)

JamalNUMAN — Sun, 21 Jan 2024 05:31:45 GMT

Yes, we need it

Re: Use Select by Attributes to select greatest n records (FGDB)

Bud — Mon, 26 Feb 2024 03:28:30 GMT

To me, it's not really acceptable that Esri's main/proprietary datatype doesn't support this (without creating a copy of the data). It's a basic GIS task: select the 4 biggest cities.

Re: Use Select by Attributes to select greatest n records (FGDB)

Bud — Tue, 17 Sep 2024 15:20:43 GMT

Idea: Make Query Table — Sort data (and then generate dynamic OBJECTID)

Re: Use Select by Attributes to select greatest n records (FGDB)

Bud — Mon, 17 Mar 2025 05:21:52 GMT

FGDB SQL is too limited to be useful to us.