title: select rows with max date till current date as well as all the rows greater than today date
body: <p>Suppose I've table </p>
  
  <p>table :: <em>tbl_group_txn</em></p>
  
  <pre><code>GroupName   Indvd_id    effective_date                  amount
  --------------------------------------------------------------
  JPN001      001         2015-11-13 00:00:00.000         70,000
  JPN001      002         2015-11-13 00:00:00.000         80,000
  
  JPN001      003         2015-11-16 00:00:00.000         90,000
  JPN001      004         2015-11-16 00:00:00.000         75,000
  
  JPN001      005         2015-11-29 00:00:00.000         100,000
  JPN001      006         2015-11-29 00:00:00.000         125,000
  
  CHN001      007         2015-11-29 00:00:00.000         60,000
  CHN001      008         2015-11-15 00:00:00.000         70,000
  CHN001      009         2015-11-15 00:00:00.000         70,000
  CHN001      010         2015-11-18 00:00:00.000         40,000
  --------------------------------------------------------------
  </code></pre>
  
  <p>My requirement is to get the rows under the same group with <strong>MAX(effective_date )rows</strong> for the date till today date and <strong>all the rows greater than today date</strong>.</p>
  
  <p>In case of group <strong>JPN001</strong>, the rowid 3, 4 has max date till today date and rowid 5, 6 are rows having date greater than today date. </p>
  
  <p>Similary in case of group <strong>CHN001</strong>, the rowid 10 has max date till today date and rowid 7 have date greater than today rate. </p>
  
  <p>So the output will be ::</p>
  
  <pre><code>GroupName   Indvd_id    effective_date                  amount
  --------------------------------------------------------------      
  JPN001      003         2015-11-16 00:00:00.000         90,000
  JPN001      004         2015-11-16 00:00:00.000         75,000
  
  JPN001      005         2015-11-29 00:00:00.000         100,000
  JPN001      006         2015-11-29 00:00:00.000         125,000
  
  CHN001      007         2015-11-29 00:00:00.000         60,000
  CHN001      010         2015-11-18 00:00:00.000         40,000
  --------------------------------------------------------------
  </code></pre>
  
  <p>Please suggest how can I achieve this?</p>