title: SELECT only the whole row where the column is empty in SQL
body: <p>If I have the following example table, is there any way that I only keep rows where the "Closed Date" column is empty?  In this example, only the second row has an empty "Closed Date" column, the third and fourth are not. <a href="https://i.stack.imgur.com/gqH0e.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gqH0e.jpg" alt="enter image description here"></a></p>
  
  <pre><code>Unique Key,Created Date,Month,Closed Date,Latitude,Longitude
  32098276,12/1/2015 0:35,12,,40.78529363,-73.96933478,"(40.78529363449518, -73.96933477605721)"
  32096105,11/30/2015 20:09,11,11/30/2015 20:09,40.62615508,-73.9606431,"(40.626155084398036, -73.96064310416676)"
  32098405,11/30/2015 20:08,11,11/30/2015 20:08,40.6236074,-73.95914964,"(40.62360739765128, -73.95914964173129)"
  </code></pre>
  
  <p>I find this but this is not exactly I am looking for.  Could any guru enlighten?  Thanks!</p>
  
  <p><a href="https://stackoverflow.com/questions/11002722/return-empty-row-based-on-condition-in-sql-server">return empty row based on condition in sql server</a></p>
  
  <ul>
  <li>Sorry forgot to mention I use SQL Server 2014.  </li>
  </ul>