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)

相关推荐