RE: Different order than groupping

2003-07-01 Thread Jay Blanchard
[snip] SELECT sum(a), b, c FROM table WHERE statement GROUP BY b, c HAVING sum(a) > 0 The problem is that I was the results to be in descending order by sum(a). I know that GROUP BY works as an ORDER BY at the same time, but I cannot use the group function into the GROUP BY statement...! What ca

Different order than groupping

2003-07-01 Thread Themis Kafetzopoulos
Hello. I have this simple query: SELECT sum(a), b, c FROM table WHERE statement GROUP BY b, c HAVING sum(a) > 0 The problem is that I was the results to be in descending order by sum(a). I know that GROUP BY works as an ORDER BY at the same time, but I cannot use the group function into the GROU