WITH cte1 AS( SELECT COUNT(*) cnt FROM table1 WHERE.... ), cte2 AS( SELECT COUNT(*) cnt FROM table1 WHERE.... ), cte3 AS( SELECT COUNT(*) cnt FROM table 1 WHERE.... ) SELECT cte1.cnt AS cte1, cte2.cnt AS cte2, cte3.cnt AS cte3 FROM cte1, cte2, cte3 SELECT (SELECT COUNT(*) FROM table1 WHERE....) as cte1, (SELECT COUNT(*) FROM table1 WHERE....) as cte2, (SELECT COUNT(*) FROM table1 WHERE....) as cte3