摘要:
if object_id('tempdb..#xs') is not nulldrop table #xs; create table #xs(vip varchar(20), date datetime, sale float)insert into #xs(vip, date, sale)select 'A' as vip,'2013-1-1' as date, 230 as sale union allselect 'A','2013-1-5', 400 union allselect 'A' 阅读全文
摘要:
select * from (select * ,row_number() over(partition by CreateUID order by asid)num from AuctionSell) a where num >=4select * from AuctionSell a where (select count(1) from AuctionSell b where b.asid=4http://zhidao.baidu.com/question/590140177.html?quesup2&oldq=1 阅读全文