网站首页 站内搜索

搜索结果

查询Tags标签: OriginSiteID,共有 1条记录
  • sqlserver_delete from from inner join_通过表关联查询删除

    直接上SQL语句:DELETE FROM TJ_TB_Order FROM dbo.TJ_TB_Order O INNER JOIN (SELECT * FROM (SELECT OriginID,OriginSiteID,COUNT(1) c,MAX(ID) ID FROM TJ_TB_Order GROUP BY OriginID,OriginSiteID ) A WHERE A.c>1) B ON O.OriginID=B.OriginID AND O.OriginSit…

    2022/9/17 2:18:31 人评论 次浏览
扫一扫关注最新编程教程