title: Oracle Query: Get distinct names having count greater than a threshold
body: <p>I have a table having schema given below</p>
  
  <pre><code>EmpID,MachineID,Timestamp
      1,        A,01-Nov-13
      2,        A,02-Nov-13
      3,        C,03-Nov-13
      1,        B,02-Nov-13
      1,        C,04-Nov-13
      2,        B,03-Nov-13
      3,        A,02-Nov-13
  </code></pre>
  
  <p>Desired Output:</p>
  
  <pre><code>EmpID,MachineID
      1,        A
      1,        B
      1,        C
      2,        A
      2,        B
      3,        A
      3,        C
  </code></pre>
  
  <p>So basically, I want to find the Emp who have used more than one machines in the given time period. </p>
  
  <p>The query I am using is</p>
  
  <pre><code>select EmpID,count(distinct(MachineID)) from table 
  where Timestamp between '01-NOV-13' AND '07-NOV-13'
  group by EmpID having count(distinct(MachineID)) &gt; 1
  order by count(distinct(MachineID)) desc;
  </code></pre>
  
  <p>This query is given me output like this</p>
  
  <pre><code>EmpID,count(distinct(MachineID))
      1,                        3
      2,                        2
      3,                        2   
  </code></pre>
  
  <p>Can anyone help with making changes to get the output like described above in my question.</p>