title: Using DISTINCT along with GROUP BY in SQL Server
body: <p>Is there any purpose for using both DISTINCT and GROUP BY in SQL?</p>
  
  <p>Below is a sample code</p>
  
  <pre><code>SELECT DISTINCT Actors
  FROM MovieDetails
  GROUP BY Actors
  </code></pre>
  
  <p>Does anyone know of any situations where both DISTINCT and GROUP BY need to be used, to get any specific desired results?</p>
  
  <p>(The general usage of DISTINCT and GROUP BY separately is understood)</p>