Get to know tables
OVER()
Computations with OVER()
Aggregate functions with OVER()
OVER() and WHERE
Revision
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.

Console

Code editor

Result

TableConsole