用SQL語句刪除重復(fù)數(shù)
2 回答
呼喚遠(yuǎn)方
TA貢獻(xiàn)1856條經(jīng)驗(yàn) 獲得超11個(gè)贊
--聲明變量
Declare @ID Int, @PosNo Int
Declare @Table Table(
ID Int,
PosNo int
)
Declare cur Cursor Static READ_ONLY For
Select ID, PosNo
From 表
Order By EmpID, ID
Open cur
Fetch From cur Into @ID, @PosNo
While @@FETCH_STATUS = 0
Begin
If Exists(Select * From @Table Where PosNo = @PosNo)
Begin
Delete 表 Where ID = @ID
End
Else
Begin
Insert Into @Table (ID, PosNo)
Values (@ID, @PosNo)
End
Fetch Next From cur Into @ID, @PosNo
End
Close cur
DeAllocate cur
MYYA
TA貢獻(xiàn)1868條經(jīng)驗(yàn) 獲得超4個(gè)贊
select *
from (
select a.*,row_number() over (parition by Empid,CardNO,MACHNO,POSNUM,type order by id desc) rn
from table_name a
) t
where rn<=1
- 2 回答
- 0 關(guān)注
- 891 瀏覽
添加回答
舉報(bào)
0/150
提交
取消