DELETE FROM [Log_IIS].[dbo].[IISLog_table]
WHERE id not in
(select MAX(Id) from [IISLog_table] group by [RequestTime]
,[LogFilename]
,[LogRow]
,[date]
,[time]
,[cIp]
,[csUsername]
,[sSitename]
,[sComputername]
,[sIp]
,[sPort]
,[csMethod]
,[csUriStem]
,[csUriQuery]
,[scStatus]
,[scSubstatus]
,[scWin32Status]
,[scBytes]
,[csBytes]
,[timeTaken]
,[csVersion]
,[csHost]
,[csUserAgent]
,[csCookie]
,[csReferer]
,[sEvent]
,[sProcessType]
,[sUserTime]
,[sKernelTime]
,[sPageFaults]
,[sTotalProcs]
,[sActiveProcs]
,[sStoppedProcs] having count(*) > 1)
