select * from (select * ,row_number() over(partition by CreateUID order by asid)num from AuctionSell) a where num >=4 select * from AuctionSell a where (select count(1) from AuctionSell b where b.asid<=a.asid and a.CreateUID=b.CreateUID) >=4
http://zhidao.baidu.com/question/590140177.html?quesup2&oldq=1