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)