Oracle SQL - 添加一列数据不包含在任何表中
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12612467/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-19 01:07:57 来源:igfitidea点击:
Oracle SQL - Add a column with data not included in any table
提问by Americo
I have this query:
我有这个查询：
Select
Trunc(Red.Fulfilled_Dtime),
P.Email,
(Red.Points_Deducted *.003)*(1/1.02) As Redeem_Amt,
Red.Player_Id,
Red.Prize_Id,
Red.Points_Deducted
From Redemption_Log Red
Inner Join Player P On Red.Player_Id=P.Player_Id
Where Red.Prize_Id In (8907,8906,8905,8904,8903,8902,8901)
I want to add a column to my result called "Currency" in which every row in my results has the output "USD". Is this possible?
我想在我的结果中添加一个名为“货币”的列，其中我的结果中的每一行都有输出“美元”。这可能吗？
回答by John Woo
You can add virtual columnon your SELECTstatement,
你可以virtual column在你的SELECT声明中添加，
SELECT Trunc(Red.Fulfilled_Dtime),
P.Email,
(Red.Points_Deducted *.003)*(1/1.02) As Redeem_Amt,
Red.Player_Id,
Red.Prize_Id,
Red.Points_Deducted,
'USD' AS "Currency" -- <<== virtual column
FROM Redemption_Log Red
Inner Join Player P
On Red.Player_Id=P.Player_Id
WHERE Red.Prize_Id In (8907,8906,8905,8904,8903,8902,8901)
