Separating the list of value by comparing frequency
<p>I have the bellow data set output should come like less then one frequency..
i am new to sql so don't have much idea.. </p>

<p>in the input i have 3 times 1, 2 times 2, 3 times 3 and 2 times 4. output i want 2 times 1, 1 time 2, 2 times 3 and 1 time 4.. </p>

<p>Any suggestion how to achieve this output!! </p>

<p><a href="https://i.stack.imgur.com/jOPvh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jOPvh.png" alt="enter image description here"></a></p>