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

How to check local and global angular versions

 Use the command ng version (or ng v ) to find the version of Angular CLI in the current folder. Run it outside of the Angular project, to f...