-- window function- A window function performs a calculation across a set of table rows that are somehow related to the current row. select * from employee; select fname,salary,sum(salary) over() from ...
Window function in PostgreSQL performs a calculation across a set of rows related to the current row within a query. Unlike aggregate functions, which return a single value for a group of rows, window ...