title: Multiple Top 1 based on count
body: <p>I have a table with multiple customers and multiple transaction dates.</p>
  
  <pre><code>Cust_ID Trans_Date
  ------- ----------
  C01 2012-02-18
  C01 2012-02-27
  C01 2012-03-09
  C02 2012-02-15
  C02 2012-03-09
  C03 2012-03-30
  C01 2013-01-14
  C02 2013-02-21
  C03 2013-01-15
  C03 2013-03-07
  </code></pre>
  
  <p>I want to find customers with most transaction in each year and the transactions for that customer.
  Below is the result I am expecting. </p>
  
  <pre><code>Year    Cust_ID    nTrans
  ----    -------    ------
  2012    C01        3
  2013    C03        2
  </code></pre>
  
  <p>Can anybody help with the script? SQL Svr version 2012.</p>
  
  <p>Thanking you in advance,
  Thomas</p>