topic SELECT * FROM building ORDER BY ShapeArea DESC LIMIT 5 in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/select-from-building-order-by-shapearea-desc-limit/m-p/636682#M24431 <HTML><HEAD></HEAD><BODY><SPAN>I want to select the one hundred largest building and then export to a CSV file.</SPAN><BR /><BR /><SPAN>SELECT *</SPAN><BR /><SPAN>FROM building</SPAN><BR /><SPAN>ORDER BY ShapeArea DESC</SPAN><BR /><SPAN>LIMIT 5</SPAN><BR /><BR /><SPAN>How is the Syntax in ArcGIS for this Statement??</SPAN><BR /><BR /><SPAN>And how can I best do automatically?</SPAN><BR /><BR /><SPAN>In an attribute table, one can not simply select the top ten and then copy all the values �??�??right?</SPAN><BR /><BR /><SPAN>THX Martikainen</SPAN></BODY></HTML> Mon, 06 Feb 2012 18:15:28 GMT FabianMarthaler 2012-02-06T18:15:28Z SELECT * FROM building ORDER BY ShapeArea DESC LIMIT 5 https://community.esri.com/t5/arcgis-enterprise-questions/select-from-building-order-by-shapearea-desc-limit/m-p/636682#M24431 <HTML><HEAD></HEAD><BODY><SPAN>I want to select the one hundred largest building and then export to a CSV file.</SPAN><BR /><BR /><SPAN>SELECT *</SPAN><BR /><SPAN>FROM building</SPAN><BR /><SPAN>ORDER BY ShapeArea DESC</SPAN><BR /><SPAN>LIMIT 5</SPAN><BR /><BR /><SPAN>How is the Syntax in ArcGIS for this Statement??</SPAN><BR /><BR /><SPAN>And how can I best do automatically?</SPAN><BR /><BR /><SPAN>In an attribute table, one can not simply select the top ten and then copy all the values �??�??right?</SPAN><BR /><BR /><SPAN>THX Martikainen</SPAN></BODY></HTML> Mon, 06 Feb 2012 18:15:28 GMT https://community.esri.com/t5/arcgis-enterprise-questions/select-from-building-order-by-shapearea-desc-limit/m-p/636682#M24431 FabianMarthaler 2012-02-06T18:15:28Z