SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table exchange_transactions
(
  id integer primary key autoincrement,
  transaction_id integer,
  surgeon varchar(100)
)
insert into exchange_transactions
(transaction_id, surgeon) values
 (100, 'Lucille Torres')
,(100, 'Lucille Torres')
,(200, 'Lucille Torres')
WITH CTE_DUPS AS
(
  SELECT id,
  ROW_NUMBER() OVER (
      PARTITION BY surgeon, transaction_id
      ORDER BY id) AS rn
  FROM exchange_transactions
  WHERE surgeon = 'Lucille Torres'
)
DELETE 
FROM exchange_transactions
WHERE id IN (select id from CTE_DUPS where rn > 1)
select *
from exchange_transactions
order by id


id
transaction_id
surgeon


1
100
Lucille Torres

3
200
Lucille Torres