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

Linear Regression

Linear Regression is a mathematical method used to predict the value of a continuous target variable based on one or more input features. ...