how to sum after group by return in mysql?
<p>I have a table like </p>

<pre><code>ID amount item date
1   10     sr   21/11/2016
2   10     sr   22/11/2016
2   10     sr   22/11/2016
2   10     sr   22/11/2016
3   30     sr   22/11/2016
3   30     sr   22/11/2016
3   30     sr   22/11/2016
</code></pre>

<p>i just want return data like </p>

<pre><code> amount date
   10     21/11/2016
   40     22/11/2016
</code></pre>

<p>What is the best way to get it?</p>

<p>may be group by by date, and only i amount for one id will pick and will sum then.
Thank You in Advance.</p>