如果首选语言是中文,并且将值与默认值和英语关联,则该值应不返回任何结果…
我明白这意味着…
DECLARE @preferred VARCHAR(64) SET @preferred = ‘English’
SELECT value, ( SELECT language FROM tbl [search] WHERE externID = 10 AND value = tbl.value AND language IN (‘default’, @preferred) ORDER BY NULLIF(language, ‘default’) DESC LIMIT 1 ) FROM tbl WHERE externID = 10 GROUP BY value HAVING COUNT(*) = SUM(CASE WHEN language IN (‘default’, @preferred) THEN 1 ELSE 0 END)