Select to view content in your preferred language

Selecting Minimum value of completed points using SQL

33
1
yesterday
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
New Contributor

You can try the following query:

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

0 Kudos