It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Get to know tables
OVER()
Computations with OVER()
Aggregate functions with OVER()
OVER() and WHERE
Summary
14. Summary

Instruction

Great! Let's review what we've learned so far.

  • Use <window_function> OVER() to compute an aggregate for all rows in the query result.
  • The window functions is applied after the rows are filtered by WHERE.
  • The window functions are used to compute aggregates but keep details of individual rows at the same time.
  • You can't use window functions in WHERE clauses.

Did you get that very basic idea of OVER() right? Let's find out!

Exercise

Click Next exercise to start a very short quiz.