About
Pricing
Community
Teams
Start Free Trial
Log in
MBoy
asked on
2/16/2010
SQL simple delete duplicate rows
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)))
Microsoft SQL Server 2008
2
1
Last Comment
MBoy
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Emes
2/16/2010
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
MBoy
2/16/2010
ASKER
I'm an idiot
forgot END and GO
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
forgot END and GO