Essential Books

Adding the total rows selected to every row

suggest change 
SELECT your_columns, COUNT(*) OVER() as Ttl_Rows FROM your_data_set

id | name | Ttl_Rows | —— | —— | —— | 1 | example | 5 | 2 | foo | 5| 3 | bar | 5| 4 | baz | 5| 5 | quux | 5 |

Instead of using two queries to get a count then the line, you can use an aggregate as a window function and use the full result set as the window.

This can be used as a base for further calculation without the complexity of extra self joins.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Window Fnctions:
*Setting up a flag if other rows have a common property
*Getting a running total
*Finding out-of-sequence records using the LAG function
*Adding the total rows selected to every row
*Getting the N most recent rows over multiple grouping
Table Of Contents