Selecting Minimum value of completed points using SQL

BrendanR5 — Tue, 11 Mar 2025 18:17:49 GMT

I have a table that has a Number field that lists the order that points should go in 1-18, and then I have a field called 'Completion' that determines whether or not work is completed at that point with the value 'complete' or 'incomplete'. I need to make a label class that selects the lowest number that is marked as incomplete by using an SQL selection. I have been trying at this for little while and have too little experience with SQL to figure it out.

Thank you.

Re: Selecting Minimum value of completed points using SQL

SurabhiGupta1 — Wed, 12 Mar 2025 04:37:25 GMT

You can try the following query:

SELECT MIN("Number")
FROM your_table_name
WHERE "Completion" = 'incomplete';

topic Selecting Minimum value of completed points using SQL in ArcGIS Pro Questions

Selecting Minimum value of completed points using SQL

Re: Selecting Minimum value of completed points using SQL