title: Query to fetch just one item from a table
body: <p>hr_org with the following columns :-</p>
  
  <pre><code>Org id  Spoc  Name
  123     HR    A
  123     IT    A
  123     VP    A
  67      IT    B
  78      HR    C
  78      IT    C
  </code></pre>
  
  <p>i want to create a query in which only those names come in which only IT Spoc is defined.</p>
  
  <p>For eg :-</p>
  
  <pre><code>select name 
  from hr_org
  where SPOC ='IT'
  </code></pre>
  
  <p>will give A And B 
  but for A other spoc(HR AND VP) have been defied as well. My output should just fetch B.</p>