title: Having count condition with greater than and less than for Sybase DB
body: <p>I am using below query in sybase db, i need data to show where count(Field1 &gt;=2 and Field1 &lt;=5)
  <code>Select * FROM Table1 WHERE Field1 IN( SELECT Field1 FROM Table1 GROUP BY Field1 HAVING COUNT(Field1) &gt;= 2 ORDER BY Field1</code>How can i achieve this</p>