sql 查出一张表中重复（不重复）的所有记录数据

* 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)

 

sql 查出一张表中重复（不重复）的所有记录数据

标签：color   rom   group   记录   count   sel   status   sele   div