復制代碼 代碼如下:

alter table [tablename] add [TID] int IDENTITY(1,1)

復制代碼 代碼如下:

delete from query_IP where TID not in (select max(TID) from query_IP group by SIP,EIP)

復制代碼 代碼如下:

Select * from LoginLog where ID in (select max(ID) from LoginLog group by UserID)