jontyknox

SQL Select Query

Discussion created by jontyknox on Nov 29, 2011
Latest reply on Dec 2, 2011 by bharold-esristaff
Hi there,

I am trying to construct an SQL query using the 'Select' tool. Essentially what I am trying to figure out is how to select the first row in an attribute table, with an additional statement only allowing this record to be selected if my Boolean field (in the same attribute table) is equal to 0.

For a bit of background, this step fits into a wider process that I am running in Model builder. The tool factors into a structure that would then create a buffer around the highest ranked points (FID moving from 0 down) in the attribute table. It would then exclude those points that fall within the buffered regions around the highest ranked points (by assigning them a value of 1). This process would repeat until all points had a Boolean field value of 1. 

If you guys could lend me a hand that would be great,

Cheers, Jonty

Outcomes