SQL - Group batch by lowest status

It's been a long day and I'm not getting my head around this at the moment.
I have a table with batch numbers and statuses. What I would like to do with SQL is get a result with one row for each batch with the lowest status. See the image below for what I'm getting at.
Does anyone have a suggestion on how I would set this SQL statement up?
Thanks,
Todd

SQL-Question.bmp
LVL 7
shambaladAsked:
Who is Participating?
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
Select batch, min(status) from table group by batch
0
 
shambaladAuthor Commented:
Perfect!
0
 
shambaladAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.