<div>
I'm an idiot <br />
<br />
forgot END and GO
</div>


<div>
<div class="content wysiwyg-content">
I can't figure out what I'm doing wrong. &nbsp;I know I'm being toopid<br />
<br />
DELETE<br />
FROM MasterKeyData<br />
WHERE ((OperatorCode IS NULL) <br />
AND <br />
(MasterKeyDataID NOT IN (SELECT MAX(MasterKeyDataID) FROM MasterKeyData &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GROUP BY IPAddress, EventCode, EventType)))<br />

</div>
</div>


I can't figure out what I'm doing wrong.  I know I'm being toopid

DELETE
FROM MasterKeyData
WHERE ((OperatorCode IS NULL) 
AND 
(MasterKeyDataID NOT IN (SELECT MAX(MasterKeyDataID) FROM MasterKeyData	GROUP BY IPAddress, EventCode, EventType)))


SQL simple delete duplicate rows

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.