title: Issue with group by statement in sqldf
body: <p>I have a dataset with two columns(character) - text, source , I want to create a dataset such that if a particular value in text column is present less than 5 times. I am using below code but it is giving only first occurrence instead I need all the observations which satisfies that condition. For example: 'iphone' is present for 4 times in text , so I need all the 4 observations and their corresponding source but I am getting only one observation for that. </p>
  
  <pre><code>test = sqldf('select * , count(*) as count from base group by text having count &lt; 5')
  </code></pre>
  
  <p>I am familiar with <code>proc sql</code> in SAS and I have recently started learning R. Does <code>sqldf</code> works in a different way?</p>