 <pre><code>SELECT a.* FROM tableName a INNER JOIN ( SELECT `Cut-off`, COUNT(*) totalCOunt FROM tableName GROUP BY `Cut-off` HAVING COUNT(*) &gt; 1 ) b ON a.`Cut-off` = b.`Cut-off` </code></pre> <p>for faster performance, add an <code>INDEX</code> on column <code>Cut-off</code></p> <ul> <li><a href="http://www.sqlfiddle.com/#!2/966aa/4" rel="nofollow">SQLFiddle Demo</a></li> </ul>