title: How to convert group by to partition by Sql begineer
body: <p>My Query which of group by which is working fine</p>
  
  <pre><code>select uid,count(*) from user_details where uid  &lt;&gt; '' group by uid
  </code></pre>
  
  <p>Trying to convert to partition by
  My query with partion by which is not as expected</p>
  
  <p><code>select uid,(count(uid) OVER (
          PARTITION BY uid
      )) counts from user_details where uid  &lt;&gt; ''</code></p>
  
  <p>no error message output is not correct. </p>
  
  <pre><code> uid, Count As |
   Dates_not_found, 1,192 |
   Dates_not_found, 1,192 |
  </code></pre>