title: SQL reduce duplicates in union clause
body: <p>let's say for example I have the following query:</p>
  
  <pre><code>SELECT City, Country FROM Customers
  WHERE Country='Germany'
  UNION
  SELECT City, Country FROM Suppliers
  WHERE Country='Germany'
  ORDER BY City;
  </code></pre>
  
  <p>As you can see the <code>WHERE Country='Germany'</code> is repeated in both the targets of the union - is there any way to reduce this to a query without repetitions? I don't like my queries being too long. </p>
  
  <p>I'm currently working on Oracle. </p>