sql 查询

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