use test
select *
from
(
(select Col1,Col2 from Result where Col3='a')as T1(Col1,Col2_A)
full join
(select Col1,Col2 from Result where Col3='b')as T2(Col1,Col2_B)
on T1.Col1=T2.Col1
)
Col1 | Col2_A | Col1 |Col2_B
-----------------+------------+--------+-----------
select Col1,Col2_A,Col2_B
from
(
(select Col1,Col2 from Result where Col3='a')as T1(Col1,Col2_A)
full join
(select Col1,Col2 from Result where Col3='b')as T2(Col1,Col2_B)
on T1.Col1=T2.Col1
)
Col1 | Col2_A | Col2_B
-----------------+------------+-----------