17,140
社区成员




select abc.did from card abc,
(select id, max(status) as "status"
from card) maxcheck
WHERE abc.did = maxcheck.id
and maxcheck."status" in ('1', '3', '5')
select * from (select id,max(status) from card) abc where abc.id=xz.id and abc.status in ('2')