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

Misc Javascript points

 Nodejs can support multithreading through use of promises _ is the numeric separator for javascript, that means the numbers 10_000, 11.23_0...