rschandrastechblog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Vercel Mongo Integration
Click continue Press “I Acknowledge” Multiselect vercel projects Click “ “Connect and ...
How to Share Data Between Stored Procedures --Erland Sommarskog http://www.sommarskog.se/share_data.html
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
Plotting a Confusion Matrix for CIFAR10 using Seaborn
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
How to clear SQL Server Cache ?
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
No comments:
Post a Comment