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