title: MySql using correct syntax for the over clause
body: <p>What is the correct syntax to get the over clause to work in mysql?</p>
  
  <p>I would like to see the total sms's sent by each user without grouping it with the group by clause.</p>
  
  <pre><code>SELECT 
      username, 
      count(sentSmsId) OVER (userId) 
  FROM 
      sentSmsTable,
      userTable
  WHERE
      userId = sentUserId;
  </code></pre>