我想了解一下如何使用在select查询中创建的虚拟变量。与下面的示例一样,我已经创建了RequestDate和ReceivedDate作为select查询的一部分,我想在同一范围内的第三个select查询中使用它们。有没有可能这样做呢?请告知。
SELECT MessageId,
( SELECT
xxxx from xxx where xxx
) AS RequestDate ,
( SELECT
xxxx from xxx where xxx
) AS ReceivedDate ,
(
SELECT
ReceivedDate - RequestDate from xxxx
) as DateDiff
FROM Date发布于 2014-05-05 13:26:31
SELECT MessageId,RequestDate ,ReceivedDate ,
ReceivedDate - RequestDate as DateDiff
FROM (
SELECT MessageId,
(SELECT xxxx from xxx where xxx) AS RequestDate ,
(SELECT xxxx from xxx where xxx) AS ReceivedDate ,
FROM Date
) As Z注意:对于从DATE表返回的每一行,内部查询(SELECT xxxx from xxx where xxx)和(SELECT xxxx from xxx where xxx)必须返回单个值,否则将出现错误
Oracle update: Oracle ORA-01427__:单行子查询返回多行
https://stackoverflow.com/questions/23465198
复制相似问题