Got wrong result with GROUP BY, ORDER BY and HAVING together

I execute this query on SQL and got wrong result some time generate errors could you please help me to resolve this query

SELECT Name, COUNT(*)
FROM patientdet 
GROUP BY Name
HAVING COUNT(*) > 1 ORDER BY OrderID