![](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2F9RnWV%2FbtsEXpfBBrq%2FIQcQ5oRHQSFnf96boP539K%2Fimg.png)
SELECT * FROM (SELECT colA, colB FROM tableA UNION SELECT colA, colB FROM tableB) WHERE colA > 1 https://stackoverflow.com/questions/5437507/union-with-where-clause UNION with WHERE clause I'm doing a UNION of two queries on an Oracle database. Both of them have a WHERE clause. Is there a difference in the performance if I do the WHERE after UNIONing the queries compared to performin... stackove..