CdrView

select * from cdr where (uniqueid, billsec) in (select uniqueid, max(billsec) from cdr group by uniqueid);