shambalad
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
ASKER