title: Get min date across two rows in SQL table
body: <p>I have a table that looks like the below in SQL</p>
  
  <p><a href="https://i.stack.imgur.com/2d3PU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2d3PU.png" alt="enter image description here"></a></p>
  
  <p>I would like to select the row with the earliest date in either the PR create date or AC create date field. So in this case, I would want these two records.</p>
  
  <p><a href="https://i.stack.imgur.com/fOtPC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fOtPC.png" alt="enter image description here"></a></p>
  
  <p>I know that I can write</p>
  
  <pre><code>Select email, min(PR_create_date) from table 
  group by email
  </code></pre>
  
  <p>However, this will only find the minimum date in the PR_create_date column. How can I find the minimum date in either the PR_create_date or AC_create_date columns? </p>