Select by attribute

[AlesgerMammedov2]

I have table with drill hole. Drill hole name is repeating for each drillng interval.

For example  drill hole      interval

                      a1                1

                      a1                2

                      a1                3

                      b1                1

                      b1                3

                      b1                 4

                      c1                2

                      c1                 3

                      c1                 5

          And now I want to get rows  name drill hole with minimal interval 

 a1 1

 b1 1 

 c1  2

[FC_Basson]

See reply to your other post: https://community.esri.com/thread/181767-arcpython-work-with-table 

For the sorting part use multiple fields.

[Anonymous User]

Hello,

Please check this 
Concatenating field values using Calculate Field | ArcGIS Blog 

Thanks.

[Anonymous User]

ArcGIS Desktop 

!Drill_Hole! + str( !Intervel! )