title: SQL query completed successfully but not results
body: <p>Using SQL Server Management Studio 2017.
  I imported a list of approx 20million emails, just ran the below code to remove any duplicates:</p>
  
  <pre><code>WITH CTE AS
  (
      SELECT *,ROW_NUMBER() OVER (PARTITION BY email ORDER BY email) AS RN
      FROM dbo.cleanemails
  )
  
  DELETE FROM CTE WHERE RN&lt;&gt;1
  </code></pre>
  
  <p>It says Query executed successfully, and under the Messages tab says 10million rows affected (expected) but there is no Results tab. 
  I am wanting to export into a csv file.
  I have check the execution setting as the Parseonly and Noexec settings sometimes cause issues but they were both OFF.</p>
  
  <p>I am relatively new to SQL, any help would be appreciated.
  Studio screen shot
  <a href="https://i.stack.imgur.com/Af6T6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Af6T6.jpg" alt="enter image description here"></a>
  execution settings
  <a href="https://i.stack.imgur.com/5p7T5.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5p7T5.jpg" alt="enter image description here"></a></p>