ÇóÒ»¸ömssqlµÄsqlÓï¾ä - MS-SQL Server / »ù´¡Àà

ÅжϱíÖÐÊÇ·ñÓдóÓÚ10ÌõÒÔÉϵÄÊý¾Ý£¬
Èç¹û´æÔÚÔò°´×îºÃ¼ÈëµÄʱ¼ä£¬É¾³ýµô¶àÓàµÄÊý¾Ý¡£¡£
±£³ÖÊý¾Ý±íÖÐÖ»ÓÐ10Ìõ×îеÄÊý¾Ý¡£¡£

лл¡£

---

select ID,count(1) from TB group by ID having count(1)>10

---

SQL code:
;with t as
(
select rn=row_number()over(order by date desc),*
from tb
)
select * from t where rn>10

---

SQL code:
if (select count(1) from [Table])>10
delete from [Table] where id not in(select top 10 id from [Table] order by ʱ¼ä desc)

---

SQL code:
if (select count(1) from tb)>10
delete from tb where id not in (select top 10 id from tb order by dt desc)

---

delete a from TB a
inner join 
(select * from (select ID,DT,row=row_number() over (patition by id order by dt desc) from TB)T where row>10) b
on a.id=b.id 
and a.DT=b.DT

---

SQL code:
if exists £¨select count(1) from tb£©>10
begin
delete from tb where date not in (select top 10 date from tb order by date desc)
end

---

SQL code
{{