Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.


  • Presentation
  • Question
  • Answer

Tags
#has-images
Question

D) Oracle GROUP BY with WHERE clause example

This example uses the GROUP BY clause with a WHERE clause to return the number of shipped orders for every customer:

Answer
SELECT name, COUNT ( order_id ) FROM orders INNER JOIN customers USING (customer_id) WHERE status = 'Shipped' GROUP BY name ORDER BY name;

Here is the output:


Tags
#has-images
Question

D) Oracle GROUP BY with WHERE clause example

This example uses the GROUP BY clause with a WHERE clause to return the number of shipped orders for every customer:

Answer
?

Tags
#has-images
Question

D) Oracle GROUP BY with WHERE clause example

This example uses the GROUP BY clause with a WHERE clause to return the number of shipped orders for every customer:

Answer
SELECT name, COUNT ( order_id ) FROM orders INNER JOIN customers USING (customer_id) WHERE status = 'Shipped' GROUP BY name ORDER BY name;

Here is the output:

If you want to change selection, open document below and click on "Move attachment"

The Ultimate Guide to Oracle GROUP BY with Examples
get the year information from the order’s dates. Unlike the previous examples, we used an expression that returns the year in the GROUP BY clause. The following picture illustrates the result: <span>D) Oracle GROUP BY with WHERE clause example This example uses the GROUP BY clause with a WHERE clause to return the number of shipped orders for every customer: 1 2 3 4 5 6 7 8 9 10 11 SELECT name, COUNT( order_id ) FROM orders INNER JOIN customers USING(customer_id) WHERE status = 'Shipped' GROUP BY name ORDER BY name; Here is the output: Note that the Oracle always evaluates the condition in the WHERE clause before the GROUP BY clause. E) Oracle GROUP BY with ROLLUP example The following statement computes the sales amo

Summary

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.