为多个辅助加入记录选择1条记录
问题描述:
查询为每个相关联的人选择1个潜在顾客。为多个辅助加入记录选择1条记录
我怎么能按Lead_ID + MAX(person.Created_Timestamp)
select
top 100 lead.lead_id,person.first_name,person.last_name,person.gender,person.modified_ts
from lead
left join person on person.lead_id=lead.lead_id
left join person_email on person_email.person_id=person.person_id
left join person_address on person_address.person_id=person.person_id
left join address_location on person_address.address_location_id=address_location.address_location_id
where address_location.state_code = 'QL'
答
select
lead.lead_id, MAX(person.Created_Timestamp)
from lead
left join person on person.lead_id=lead.lead_id
left join person_email on person_email.person_id=person.person_id
left join person_address on person_address.person_id=person.person_id
left join address_location on person_address.address_location_id=address_location.address_location_id
where address_location.state_code = 'QL'
GROUP BY lead.lead_id