Re: Group Balance Results, Then Count All the Results
> You don't have to put AS before using an alias?
The manual is your friend. Its page on Select shows [as] in square brackets, which means it's optional.
If you just want the number of different credit_limit values ...
select count(*) from select distinct credit_limit from customer;
Subject
Written By
Posted
September 29, 2015 11:55AM
September 29, 2015 12:07PM
September 29, 2015 12:52PM
Re: Group Balance Results, Then Count All the Results
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.