title: Excluding fields while using Over() function in SQL
body: <p>I am using a <code>count(field_name) Over(partition by field_name)</code> function in sql and wanted to only show the values greater than 1. I found that I cannot use an aggregate function in the where or having clause and was hoping there was another way, short of writing a function as I do not have write privileges. </p>
  
  <p>Any help would be greatly appreciated.
  Thanks</p>