Group by for calculations

rbuser

Hi

How to group the query results based on a calculation? And how to put it in
the sort list?

For example

SELECT A, SUM(B)
FROM C
GROUP BY SUM(B) DESC
ORDER BY SUM(B) DESC

This is a legal SQL text. We use it sometimes.

Thanks

Ferenc Lendvai

digitalmetaphors

This isn't supported on all SQL engines. We have to support the least common
demoninator for SQL engines in DADE. Unfortunately, again, you'll have to
edit the SQL text to enter this SQL for your query, and lose the query tools
support for this query dataview.


Cheers,

Jim Bennett
Digital Metaphors