Query regarding aggregate function

[surovi99]

Hi,

I am currently working on advanced databases where I need to replace a GROUP BY clause by an aggregate function.Is it possible for an aggregate function to do the job of a GROUP BY clause? If yes, I will be grateful if somebody would cite an example.

Many thanks in advance

 

[r937]

do the job of?"

no, it's not possible

of course, one doesn't always need a GROUP BY clause when dealing with aggregate functions, as the entire intermediate result set (what is obtained from the FROM clause after filtering by the WHERE clause) will be regarded as a single group

the classic example of this is

select count(*) as rows from daTable

r937.com | rudy.ca