[Solved] Need SQL Script
[ad_1] If the possible values are only ‘Breachend’ and ‘Not Breached’, you can GROUP BY incident_number and get the minimum as ‘Breached’ < ‘Not Breached’. SELECT incident_number, min(has_breached) has_breached FROM elbat GROUP BY incident_number; 1 [ad_2] solved Need SQL Script