topic Querying first N rows in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/querying-first-n-rows/m-p/96391#M436 <HTML><HEAD></HEAD><BODY><SPAN>Is there a way to get the first N rows with a query?&nbsp; I've tried the standard SQL ".../query?where=rownum&lt;10", but that caused an error.&nbsp; </SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>eric</SPAN></BODY></HTML> Fri, 24 Sep 2010 18:20:33 GMT EricShort 2010-09-24T18:20:33Z Querying first N rows https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/querying-first-n-rows/m-p/96391#M436 <HTML><HEAD></HEAD><BODY><SPAN>Is there a way to get the first N rows with a query?&nbsp; I've tried the standard SQL ".../query?where=rownum&lt;10", but that caused an error.&nbsp; </SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>eric</SPAN></BODY></HTML> Fri, 24 Sep 2010 18:20:33 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/querying-first-n-rows/m-p/96391#M436 EricShort 2010-09-24T18:20:33Z Re: Querying first N rows https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/querying-first-n-rows/m-p/96392#M437 <HTML><HEAD></HEAD><BODY><SPAN>Eric,</SPAN><BR /><BR /><SPAN>I'm not sure if you ever got a reply to this but the solution would be something like:</SPAN><BR /><BR /><SPAN>/MapServer/28/query?where=NAME+LIKE+%27%25OPEN%25%27+AND+ROWNUM+%3C%3D+3&amp;f=html</SPAN><BR /><BR /><SPAN>Do you also know if there is a way to do something like ROWNUM via ArcObjects as this is essentially Oracle specific and wouldn't work for data in a File Geodatabase for example.</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 05 Jan 2011 09:23:29 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/querying-first-n-rows/m-p/96392#M437 AndrewCox 2011-01-05T09:23:29Z