View Incident Report

Serious

Reported By: Elevate Software
Reported On: 7/2/2004
For: Version 4.08 Build 1

# 1776 SELECT TOP N Clause Not Working Properly With GROUP BY Clause

When executing a SELECT query with a GROUP BY clause and a TOP N clause, the TOP N clause does not work properly.

SELECT custno, sum(itemstotal) AS Total
FROM customer INNER JOIN orders ON customer.custno=orders.custno
GROUP BY 1
ORDER BY 2 DESC
TOP 3

Resolution

Fixed Problem on 7/10/2004 in version 4.09 build 1

More Support Options