title: Checking availability of data in columns of table in SQL?
body: <p>Iam having table TestTable where i have few columns say</p>
  
  <pre><code>            C1  | C2 | C3 | c4
              'ab'|  1 | 09 |          //CASE1 [ must return 1]
                  |    |    |          //CASE2 [ must return 0]
  </code></pre>
  
  <p>I want to check if data in that table is present if any of columns data is present i want my value to be 1 , if all the columns are blank(No Data) then i want my value to be 0</p>
  
  <p>Can any one help, i have no idea expect this condition in front of me.</p>