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

[Bud]

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-wit...
• Select the 3 features that have the largest attribute value

[Bud]

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.

[JamalNUMAN]

Yes, we need it

[Bud]

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. 

[Bud]

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

[Bud]

Related: Is ArcGIS Pro the right tool for tabular geodatabase analysis?

FGDB SQL is too limited to be useful to us.