Question

一米,用别物指计算栏。这里是实际法典Im试图工作、对相似性进行计算和在相同等级为3个或3个以上的情况下返回的配对器。

select [FirstName], difference([FirstName],  mitch ) as similarity
from [Dev].[dbo].[Name]
where similarity > 2
order by similarity desc

特殊信息:

字母名称相似。

由于相似性不是真正的一栏,我如何做这项工作?

Answer 1

插图和计算在选标(<代码>WHERE和)阶段之后进行的查询(。因此,可在<代码>中提及。 WHERE 条款或载于JOIN中,因为它们尚未存在。您也可使用<代码>上的询问。缩略语条款作为子类,或可重复<代码>中的计算。 WHERE 条款:

select * 

from
(select [FirstName], difference([FirstName],  mitch ) as similarity
from [Dev].[dbo].[Name]) src

where similarity > 2
order by similarity desc

or

select [FirstName], difference([FirstName],  mitch ) as similarity
from [Dev].[dbo].[Name]
where difference([FirstName],  mitch ) > 2
order by similarity desc

Answer 2

所有答案都能够解决你的问题,但就复杂局势而言,你只能重复你的询问。

正确的方式是使用。 CROSS and AppLY

select [FirstName], similarity
from [Dev].[dbo].[Name]
cross apply
  (
     select similarity =
     difference([FirstName],  mitch )  
  )computed_column
where similarity > 2
order by similarity desc

页: 1

Answer 3

Try:

SELECT * 
  FROM (
        SELECT [FirstName], difference([FirstName],  mitch ) as similarity
            FROM [Dev].[dbo].[Name]
        ) a
WHERE similarity > 2
ORDER BY similarity desc

Answer 4

select [FirstName], difference([FirstName],  mitch ) as similarity
from [Dev].[dbo].[Name]
where difference([FirstName],  mitch ) > 2
order by 2 desc

You can t reference column aliases in where clause

友情链接