title: Compare multiple values in same column
body: <pre><code>id  vid Amount  Date
  a   1   10      Today
  a   1   5       Yesterday
  b   2   6       Today
  b   2   7       Yesterday   
  </code></pre>
  
  <p>How to Get the row where amount for today is greater than amount for yesterday group by id and vid. Date column is in date time format for today's date and yesterday's </p>
  
  <p>I require the first row as result </p>