我有下表：
Player Name Nationality
--------------------------------
Romelu Lukaku Belgian
Christian Pulisic American
Kai Havertz German
Masoun Mount British
Reece James British
Edouard Mendy French
N'Golo Kante French
Hakim Ziyech Morrocan
Timo Werner German
Thiago Silva Brazilian
Ross Barkley British
我嘗試了以下查詢：
SELECT
REPLACE([Player Name], 'Reece', 'John'),
REPLACE([Player Name], 'Christian', 'Chris')
FROM
Players
此查詢回傳兩列，而不僅僅是一列。如何使查詢成為一個，以便只回傳一列？
uj5u.com熱心網友回復：
您可以使用UNIONtojoin 垂直行
SELECT REPLACE([Player Name], 'Reece', 'John') as name FROM Players
UNION
SELECT REPLACE([Player Name], 'Christian', 'Chris') FROM Players
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/492352.html
標籤：sql