SQLzoo.net

Group by day of the week (using date functions)

Oracle

We might want to count, or find the average by days of the week. This approach uses the date functions.

In this example we note that top of the pops usually goes out on a Thursday or Friday.



Specific to Oracle

Related links:

  • DATES