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

 using Microsoft.AspNetCore.Mvc; using System.Xml.Linq; using System.Xml.XPath; //<table class="common-table medium js-table js-stre...