SELECT * FROM building ORDER BY ShapeArea DESC LIMIT 5

[FabianMarthaler]

I want to select the one hundred largest building and then export to a CSV file.

SELECT *
FROM building
ORDER BY ShapeArea DESC
LIMIT 5

How is the Syntax in ArcGIS for this Statement??

And how can I best do automatically?

In an attribute table, one can not simply select the top ten and then copy all the values �??�??right?

THX Martikainen