删除重复数据，留一条

--删除重复sl_inbox
 delete  a
 from sl_inbox a
 where exists(select 1 
              from MMV_DB_SLCHONGFU b
              where b.box=a.box and b.ofspstate=a.ofspstate 
              and b.id>a.id) 

 

 

ALTER view [dbo].[MMV_DB_SLCHONGFU]
as
select * from sl_inbox where box in (
SELECT box FROM (
SELECT BOX,COUNT(*) AS QUANTITY,OFSPSTATE FROM(
select * from sl_inbox 
--where intime>'2018-12-01'
 ) a GROUP BY BOX,OFSPSTATE ) b WHERE QUANTITY>1)

GO