how to select all of duplicate record in mysql
<p>My records is: </p>

<pre><code>name    |   id  |   AVG(point) as point
a       |   1   |   6
b       |   2   |   6
c       |   3   |   5
d       |   4   |   5
e       |   5   |   4
f       |   6   |   3
g       |   7   |   2
</code></pre>

<p>How to select record below:</p>

<p>1.I want to select top 3 record, result follow: </p>

<pre><code>name    |   id  |   AVG(point) as point
a       |   1   |   6
b       |   2   |   6
c       |   3   |   5
d       |   4   |   5
e       |   5   |   4
</code></pre>

<p>2.I want to select record not into top 3, result follow:</p>

<pre><code>name    |   id  |   AVG(point) as point
f       |   6   |   3
g       |   7   |   2
</code></pre>

<p>How can I do?</p>