sql 查出一张表中重复(或者不重复)的所有记录数据
例:
select * from LoanApply where ApplyTime>'2020-4-25' and CheckStatus=3 and BidderNo in (select BidderNo from LoanApply where ApplyTime>'2020-4-25' group by BidderNo having count(1) < 2)
例:
select * from LoanApply where ApplyTime>'2020-4-25' and CheckStatus=3 and BidderNo in (select BidderNo from LoanApply where ApplyTime>'2020-4-25' group by BidderNo having count(1) < 2)