title: Replace Group By clause with any other clause
body: <p>In below query, I am using <code>GROUP BY</code> clause to get list of recently updated records depends on updated date. But I would like to have the query without a <code>GROUP BY</code> clause because of some internal reasons. Can please any one help me to solve this.</p>
  
  <pre><code>SELECT Proj_UpdatedDate,
         Proj_UpdatedBy
  FROM   ProjectProgress PP
  WHERE  Proj_UpdatedDate IN (SELECT MAX(Proj_UpdatedDate)
                              FROM   ProjectProgress
                              GROUP BY
                                     Proj_ProjectID)
  ORDER BY
         Proj_ProjectID
  </code></pre>