<p>Selecting the union:</p>

<pre><code>select * from table1 
union 
select * from table1_backup 
</code></pre>

<p>What is the query to select the intersection?</p>

In SQL Server
intersect
```
```
select * from table1 
intersect
select * from table1_backup
```
```