Thanks a Lot

Here "N" is not the number of calls.

This is for finding the N th maximum. we have the join to deal with the one to many relation ship. so Just...

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...