使用聚合连接表

I am trying to (efficiently) fetch rows from the connections table, where the startdate is the latest within cpid - for selected cpid's.I am trying to (efficiently) fetch rows from th