Reported By: Elevate Software Reported On: 12/17/2003 For: Version 4.01 Build 1
# 1515Mixing an ORDER BY and GROUP BY Clause Together Can Cause Incorrect Grouped Results Mixing an ORDER BY and GROUP BY in the same SQL SELECT statement can cause the grouping to be incorrect, with repeated groups in some cases.
SELECT customerno, count(customerno)
FROM downlog
WHERE releasenumber=4.01
GROUP BY 1
ORDER BY 2 DESC
ResolutionFixed Problem on 12/20/2003 in version 4.02 build 1