在 SQL 更新中使用 Distinct

本文介绍了在 SQL 更新中使用 Distinct的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

这是我需要转换为更新的选择:

Here is the Select I need to convert to an Update:

SELECT DISTINCT f.SectionID, f.Name, v.Enabled FROM SETTING_VALUE v INNER JOIN SETTING s ON v.SettingID = s.SettingID INNER JOIN LU_FIELD f ON f.FieldID = s.FieldID WHERE v.DisplayValue LIKE '%Miami%' AND f.ControlName LIKE '%City%'

我的尝试:

UPDATE SETTING_VALUE SET Enabled = 0 FROM SETTING_VALUE v INNER JOIN SETTING s ON v.SettingID = s.SettingID INNER JOIN LU_FIELD f ON f.FieldID = s.FieldID WHERE v.DisplayValue LIKE '%Miami%' AND f.ControlName LIKE '%City%'

不知道如何应用 Distinct

Not sure how to apply Distinct

推荐答案

根据您的评论，所有匹配的行都应该更新您不需要区分.只需执行此操作:

Based on your comment, all of the matching rows should be updated you don't need distinct. Just execute this:

UPDATE SETTING_VALUE SET Enabled = 0 FROM SETTING_VALUE v INNER JOIN SETTING s ON v.SettingID = s.SettingID INNER JOIN LU_FIELD f ON f.FieldID = s.FieldID WHERE v.DisplayValue LIKE '%Miami%' AND f.ControlName LIKE '%City%'

您在选择中看到的所有内容都会更新.

Everything that you saw in your select will be updated.