获取每组值中的最小值:
select a.*, b.*
from ajoin b on a.AID=b.BID
where b.BID in
(select Min(b1.BID)
from a a1
left join b b1 on a1.AID=b1.BID
group by a1.AID
)
获取每组值中的最大值:
select a.*, b.*
from ajoin b on a.AID=b.BID
where b.BID in
(select Max(b1.BID)
from a a1
left join b b1 on a1.AID=b1.BID
group by a1.AID
)