DB2 AS/400 iseries在where子句中使用别名 [英] DB2 AS/400 iseries Use alias in where clause

问题描述

我正在尝试在where子句中使用列的别名.例如:

I'm trying to use the alias of a column in the where clause. for example:

SELECT col1 AS alias1, col2 + col3 as sums 
FROM my_table
WHERE sums > 10

但是随后我收到一条错误消息:

But then I get an error message saying:

列总计不在指定表中.

Column sums not in specified tables.

反正我能做到吗?

推荐答案

如果您真的想在 WHERE 中使用别名，而不是列本身，则可以使用派生表来实现:

If you really want to use alias in WHERE, not the column itself, you can do it with derived table :

SELECT a.* 
FROM
(
  SELECT lmITNO AS Item_Number, lmBANO AS Lot, lmSTAS AS Status, 
  lmRORN AS Order_Number 
  FROM MVXJDTA.MILOMA 
) a
WHERE a.Status = 'CCC'
....

这篇关于DB2 AS/400 iseries在where子句中使用别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！