MYSQL : Find duplicate

Just my reference..


select orderid, count(orderid) as totalorder
from order_list
group by orderid
order by totalorder desc;


will listed orderid and total duplicate.