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)

 

posted @ 2020-05-14 17:01  代码沉思者  阅读(732)  评论(0编辑  收藏  举报