title: MySQL-Statement. How do i skip rows in query where all rows equal null
body: <p>I have created a query to construct a table with the following code:</p>
  
  <pre><code>SELECT Date, 
      SUM(CASE WHEN UniqueId = 'NonComLong' THEN Value ELSE NULL END) AS 'NonComLong',
      SUM(CASE WHEN UniqueId = 'NonComShort' THEN Value ELSE NULL END) AS 'NonComShort',
          SUM(CASE WHEN UniqueId = 'NonComNetLong' THEN Value ELSE NULL END) AS 'NonComNetLong',
          SUM(CASE WHEN UniqueId = 'NonComPos' THEN Value ELSE NULL END) AS 'NonComPos',
          SUM(CASE WHEN UniqueId = 'TotalPositions' THEN Value ELSE NULL END) AS 'TotalPositions',
          SUM(CASE WHEN UniqueId = 'NonComPosShare' THEN Value ELSE NULL END) AS 'NonComPosShare'
  FROM fundamental_data WHERE AttributeId = 160 AND Date &gt;= '2011-06-14'
  GROUP BY Date
  ORDER BY Date; 
  </code></pre>
  
  <p>The above code returns the following table:</p>
  
  <p><a href="https://i.stack.imgur.com/Q9mCS.png" rel="nofollow noreferrer">Image of table</a></p>
  
  <p>I would like to write a piece of in which i can skip a row if all columns except the date column returns NULL. Is that possible?</p>
  
  <p>Thanks in advance!</p>