Select to view content in your preferred language

Selecting Minimum value of completed points using SQL

144
1
03-11-2025 11:17 AM
BrendanR5
New Contributor

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. 

Tags (3)
0 Kudos
1 Reply
SurabhiGupta1
Emerging Contributor

You can try the following query:

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

0 Kudos