title: Get Top 3 Records By Date By Day SQL Server 2012
body: <p>I have table with rows that look like this:</p>
  <pre><code>DateTime, Field1, Field2, Field3
  </code></pre>
  <p>I want to get the TOP 3 records by date, by day. For one record I would execute</p>
  <pre><code>SELECT TOP(3) * 
  FROM tum 
  </code></pre>
  <p>I need that for each day. I am assuming I would use partition or cross apply, but the actual syntax for this is not clear to me.</p>