<div class="container">
<div class="line number1 index0 alt2"><code class="sql keyword">SELECT</code> <code class="sql plain">nom, </code><code class="sql color2">COUNT</code><code class="sql plain">(*)</code></div>

<div class="line number2 index1 alt1"><code class="sql keyword">FROM</code> <code class="sql keyword">table</code></div>

<div class="line number3 index2 alt2"><code class="sql keyword">GROUP</code> <code class="sql keyword">BY</code> <code class="sql plain">nom</code></div>

<div class="line number4 index3 alt1"><code class="sql keyword">HAVING</code> <code class="sql color2">COUNT</code><code class="sql plain">(*)&gt;1;</code></div>
</div>