Select by attribute

Question

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

Anonymous User · Answer

ArcGIS Desktop

!Drill_Hole! + str( !Intervel! )

Anonymous User · Answer

Hello,

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

Thanks.

FC_Basson · Answer

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

For the sorting part use multiple fields.