Well since you are already going down the path of sub-query...
You need to do the TOP 3/ORDER BY TOTAIS - there is no way around that.
If you want them to then be ordered by CLASS DESCRIPTION, then I guess you put that in another SUBQUERY - order by class description...
Code:SELECT * FROM (SELECT TOP 3 * FROM (...) ORDER BY TOTAIS DESC) ORDER BY CLASSE




Reply With Quote