How to merge query result columns in MSSQL?

Question

SQL Server

Good afternoon, please tell me how to write a query in MSSQL, which will combine the results of others. For example, I want the following three queries to appear in one line with columns a,b,c and, accordingly, the values ​​​​in them 1,2,3

select '1' as 'a'
select '2' as 'b'
select '3' as 'c'

In real life, the selects themselves, of course, will be more voluminous :)

Answer 1

PIVOT .
PIVOT / Sudo Null IT News
Or you need:

SELECT (select '1') as [a], (select '2') as [b], (select '3') as [c]

?

Answer 2

select '1' as 'a', '2' as 'b', '3' as 'c'