SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

The PostgreSQL relational database management system (RDBMS) extends the standard SQL3 it implements with several conveniences for application development. Among the most useful extensions are window ...