Remove result set doesnt meet criteria
I think this query will work for you :


select 
  order_item_id,
  order_id,
  invoice_id,
  invoice_type
from your_table
where order_item_id in 
(select order_item_id from your_table where invoice_type = 'final' group by order_item_id)