[Solved] Need SQL Script

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;