sql查询 有两个查询同一个表怎么把这两个合并在一起查询

Question

如题所述

Answer 1

select (select * from A ) as 别名,（select * from A）as 别名,...... from

A as a
where

T-SQL,子查询