Remove Duplicate in Verified List

[ErSKS]

Who were verified more times?

[ErSKS]

All Duplicate Entries

SELECT entrance_rank, COUNT(*) c FROM student GROUP BY entrance_rank HAVING c > 1;

IOE Rank	Attempts
695	2
975	2
1079	2
1137	2
1153	2
1211	2
1265	2
1267	2
1366	2
1412	2
1426	2
1594	2
1607	2
1817	2
1921	2
1931	2
2024	2
2075	2
2148	2
2193	2
2327	2
2343	2
2402	2
2408	2
2464	2
2535	2
2591	2
2630	2
2702	2
2719	2
2825	2
2864	2
3145	2
3175	2
3177	2
3257	2
3304	2
3406	2
3923	2
4126	2
4359	2
4405	2
4584	2
4612	2
4687	2
4697	2
4736	2
4746	2
4955	2
5014	2
5061	2
5301	2
5449	2
5460	2
5616	2
5711	2
5718	2
5722	3
5825	2
5851	2
5911	2
6010	2
6087	2
6352	3
6407	2
6754	2
6774	2
6778	2

[ErSKS]

2 Applicants verified two times

SELECT entrance_rank, COUNT(*) c FROM student WHERE verified=1 GROUP BY entrance_rank HAVING c > 1;

IOE Rank	Attempts
3175	2
5722	2