title: How to select a data from a table without particular value in a row in MSSQL
body: <p>I am new MsSQL. I am doing a query as follows </p>
  
  <p>I have a table called Table1 as</p>
  
  <pre><code>   sno    name
       1     raj
       2     sam
       3     jim
       4     Julia  
  </code></pre>
  
  <p>I wanted the select the <code>select name FROM Table1  except value= jim</code></p>
  
  <pre><code>    output Display as below
  
              name
               raj
               sam
               Julia 
  </code></pre>
  
  <p>So how can I acheive it.</p>