B) Oracle GROUP BY
with an aggregate function example
The following statement returns the number of orders by customers:
SELECT customer_id, COUNT ( order_id ) FROM orders GROUP BY customer_id ORDER BY customer_id; |
B) Oracle GROUP BY
with an aggregate function example
The following statement returns the number of orders by customers:
B) Oracle GROUP BY
with an aggregate function example
The following statement returns the number of orders by customers:
SELECT customer_id, COUNT ( order_id ) FROM orders GROUP BY customer_id ORDER BY customer_id; |
status | not learned | measured difficulty | 37% [default] | last interval [days] | |||
---|---|---|---|---|---|---|---|
repetition number in this series | 0 | memorised on | scheduled repetition | ||||
scheduled repetition interval | last repetition or drill |