如何向SQL查询添加具有单个值的用户定义列

I currently have a SQL query that produces a table with around 10M rows. I would like to append this table with another column that has the same entry for all 10M rows. I currently have a SQL query that produces a ta