title: SQL select query with one or two column excluded
body: <p>how to write a select query with one or two column excluded instead of list down required columns.</p>
  
  <p>for example we have a table Table1 with 10 columns (col_1,col_2,col_2 ..... col_10)
  and we just want select col_1 to col_8.</p>
  
  <p>instead of writing like </p>
  
  <pre><code>Select col_1, col_2, col_3 .... col_8 from Table1
  </code></pre>
  
  <p>should we select like this</p>
  
  <pre><code>Select -(col_9, col_10) * from Table1
  </code></pre>