This is for the N th maximum . Please replace N with 2 .
please try this.
select call_Result_id from Customer c, Call_Results CR1
where c.custId=CR1.custId
and (N-1)=(Select count(distinct (Call_Result_id)) from Call_Results CR2 where...
Kindest Regards,
Anthony Surendran