How to rank rows considering ties?
How to show numbers 1 1 3 4 5 5 7… in PostgreSQL query
PostgreSQL Window Function with equality predicate
I have the following query in PostgreSQL. Everything works as expected. It returns a single row for each grp. The row returned has the greatest id within the grp.
PostgreSQL window function for sum per interval
The table is represented by following scripts:
Identify groups of sequential records
I have very simple table: