ex: use rowid concatenated with the duplicated key portion of the table:

SELECT * FROM loader_physician_recs
WHERE physician_id||rowid IN
(SELECT a.physician_id||a.rowid
FROM loader_physician_recs a, loader_physician_recs b
WHERE a.physician_id = b.physician_id
AND a.rowid < b.rowid);

Gregg