Thursday, January 20, 2011

DELETE DUPLICATE ROWS

DELETE FROM ##GLDBDDI WHERE ID NOT IN (
SELECT MAX(ID) FROM ##GLDBDDI GROUP BY DeviceTimeStamp )

No comments:

Post a Comment