title: How to write query to using 'Not'?
body: <p>I have to find list of UNIQUE users by user_group. User who has user_group as <code>Citrix_acc</code> should be in the list, user who has user_group as <code>REG_acc</code> should not be in the list. </p>
  
  <p>Below is my query, can you tell me where it went wrong?</p>
  
  <pre><code>SELECT distinct *  
  FROM usergroup_master 
  WHERE user_group= 'Citrix_acc' not user_group='Reg_acc';
  </code></pre>