[sql]
select ref_number,current_status,esn from jobs where esn in (
select esn from jobs group by esn having count(esnr)>1
)
;
[/sql]

However, I am not sure I understood correctly what you are trying to achieve.

HTH,

Dimitar