Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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

Press Next exercise to start a very short quiz.