sql 查出一张表中重复（不重复）的所有记录数据
时间：2021-07-01 10:21:17
帮助过：20人阅读
* 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
