delete FROM TableName
WHERE Col1 NOT IN
(
SELECT MAX(colid)
FROM TableName
GROUP BY Col1 )
WHERE Col1 NOT IN
(
SELECT MAX(colid)
FROM TableName
GROUP BY Col1 )
Subscribe to:
Post Comments (Atom)
How to highlight selected text in notepad++
–> To highlight a block of code in Notepad++, please do the following steps step-1 :- Select the required text. step-2 :- Right click...
-
//////// CSS < style > .validated_ok { border : 1px solid green } .validated_error { border : 1px solid red } .validate...
-
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using... -
///////////// Controller ViewBag.JavaScriptFunction = string .Format( "Search_Filter();" ); ///////////// HTML @ if ...
No comments:
Post a Comment