title: How can i get the NULL valued records from a table?
body: <p>In my table 1,00,000 records are there, where 1000 rows and 100 columns are there, some of the records in the table have NULL values, what i want is If the Null valued recorded of entire rows will come to first of my table it can be easy to me to check which row contains and which column contains NULL values</p>
  
  <ol>
  <li>If the Value of ROW/COLUM=NULL print all the null valued Rows and columns First</li>
  <li>Non-Null valued columns print next of the NULL valued rows </li>
  </ol>
  
  <p>My Table is like this:</p>
  
  <pre><code>Staff_ID First_Name    Last_Name
  
    1   Stephen   Jiang
    2   Ravi      chaganti
    3   Michael   Blythe
    4   NULL      NULL
    5   Jillian   NULL
    6   NULL      Vargas
  </code></pre>
  
  <p>and I want output like this:</p>
  
  <pre><code>Staff_ID  First_Name  Last_Name
  
    4   NULL      NULL
    5   Jillian   NULL
    6   NULL      Vargas
    1   Stephen   Jiang
    2   Ravi      chaganti
    3   Michael   Blythe
  </code></pre>
  
  <p>I need a query for this.</p>