テーブルの検索結果に固定値の列を加えるSQLの記述についてはこちらの記事を参照してください。
select [固定値] as [列名]
select [固定値]
select [固定値1] as [列名1], [固定値2] as [列名2], .... [固定値n] as [列名n]
select [固定値1], [固定値2], ... [固定値n]
select 'Penguin' as name
結果は以下です
name |
---|
Penguin |
select 150 as name
name |
---|
150 |
select 0.1856 as value
value |
---|
0.1856 |
select GETDATE()
(列名なし) |
---|
2022-01-10 13:49:44.258 |
select 'ぺんぎんクッキー' as pname, 250 as price, 34 as stock
pname | price | stock |
---|---|---|
ぺんぎんクッキー | 250 | 34 |