WITH TableInfo AS(
SELECT column1,column2,column3 FROM Table
UNION ALL
SELECT a.column1,column2,column3
FROM Table AS TableInfo AS b
WHERE
a.column1 = b.column1
)
SELECT * FROM TableInfo
SELECT column1,column2,column3 FROM Table
UNION ALL
SELECT a.column1,column2,column3
FROM Table AS TableInfo AS b
WHERE
a.column1 = b.column1
)
SELECT * FROM TableInfo