我想基于我的select语句中的虚拟列在查询中设置where条件。
select *,
dbo.DictanceKM(cast(u.latitude as float),
@lat,
cast(u.longitude as float),@long) as distance
from Table u
where distance < 10
是否有可能?
您可以直接指定它:
select *,dbo.DictanceKM(cast(u.latitude as float),
@lat,cast(u.longitude as float),@long) as distance
from Table u
where dbo.DictanceKM(cast(u.latitude as float),
@lat,cast(u.longitude as float),@long)<10
或使用子查询:
SELECT *
FROM (select *,dbo.DictanceKM(cast(u.latitude as float),
@lat,cast(u.longitude as float),@long) as distance
from Table u) sub
WHERE distance < 10
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句