在sql中的WHERE子句中引用别名列 [英] Referencing an Aliased Column in the WHERE Clause in sql

问题描述

如何在sql server的WHERE子句中引用别名列？

解决方案

select * from

（选择Colmn1 as C1，Colmn2 as C2 from Table）T

其中C1 ='XYZ'



你可以试试这个。

< br>

据我所知，你只能在GROUP BY，ORDER BY或HAVING子句中使用列别名。



但你可以实现它在另一种方式，你必须在一个表中定义select语句，然后你可以使用如果它



与tempTable AS

（

选择东西作为东西

来自TransactionTable

）

SELECT *

来自tempTable

什么东西> 5

How can I referenc an Aliased Column in the WHERE Clause in sql server??

解决方案

select * from
(Select Colmn1 as C1, Colmn2 as C2 from Table)T
where C1='XYZ'

You can try this.

As per my knowledge, you can only use column aliases in GROUP BY, ORDER BY, or HAVING clauses.

but you can an achieve it in another way like you have to define select statement inside a table and then you can make use if it

WITH tempTable AS
(
SELECT something AS something
FROM TransactionTable
)
SELECT *
FROM tempTable
WHERE something > 5

这篇关于在sql中的WHERE子句中引用别名列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！