寻找聚合方法或任何会导致以下结果的智能方法:
- SELECT MIN_DISTANCE(set, b) FROM {a, b, c, d} set => b
- SELECT MIN_DISTANCE(set, b) FROM {e, f, g} set => e or f or g
- SELECT MIN_DISTANCE(set, b) FROM {} set => no result
我想您只想case
表达一下:
SELECT (case when MIN_DISTANCE(set, b) in ('a', 'b', 'c', 'd') then 'b'
when MIN_DISTANCE(set, b) in ('e', 'f', 'g') MIN_DISTANCE(set, b)
end)
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句