title: T-SQL How can I get the most common value from a result set
body: <p>Trying to get a single result for the most common date in a result set :</p>
  
  <pre><code>SELECT col1, col2,  
  (SELECT MIN(CONVERT(VARCHAR,[date], 103)) FROM TABLE )  AS [Date]
  FROM TABLE WHERE [Date] BETWEEN '20160101' AND '20160131'
  </code></pre>
  
  <p>Results :</p>
  
  <p><a href="https://i.stack.imgur.com/3oP1B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3oP1B.png" alt="enter image description here"></a></p>
  
  <p>So I just want <code>15/01/2016</code>. I know I need to use a subquery and a count for this and have tried many different solutions, being a newbie I'm finding subqueries harder to get my head around than <code>JOIN</code>s especially correlated nested subqueries.</p>