title: How to remove null value from distinct column of a table in SQL?
body: <p>I want only distint city from a table but that column contains null value i dont it to come in column when i do distinct city.</p>
  
  <pre><code>select distinct city from billingsystem 
  </code></pre>
  
  <p>the output am getting is</p>
  
  <pre><code>newyork
  london
  dallas
  null 
  charles
  </code></pre>
  
  <p>I want output to be as</p>
  
  <pre><code>newyork 
  london 
  dallas
  charles
  </code></pre>
  
  <p>can anybody help me out in doing this.</p>