Re: Group Balance Results, Then Count All the Results
> what if I wanted to count all of the groups after the fact
select count(*), credit_limit, N
from (
select credit_limit, count(credit_limit) N
from customer
group by credit_limit
) sums;
A subquery needs parens and an alias ( here `sums`).
Subject
Written By
Posted
September 29, 2015 11:55AM
Re: Group Balance Results, Then Count All the Results
September 29, 2015 12:07PM
September 29, 2015 12:52PM
September 29, 2015 04:13PM
September 29, 2015 01:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.