|
You are here |
pbidax.wordpress.com | ||
| | | | |
boringsql.com
|
|
| | | | | Unlock powerful data analysis in PostgreSQL with window functions. Go beyond aggregates to rank, calculate running totals, and compare rows directly within your queries. | |
| | | | |
modern-sql.com
|
|
| | | | | LISTAGG is the new SQL standard version of GROUP_CONCAT or STRING_AGG. LISTAGG supports DISTINCT and provides an ON OVERFLOW clause to control the behavior when exceeding the maximum string length. | |
| | | | |
sqlserverfast.com
|
|
| | | | | I skipped the last two T-SQL Tuesdays. But this month, I will participate again. The monthly blog party is once more hosted by Steve Jones. His chosen topic is: Window Functions. In his invitation, Steve specifically asks for examples where Window functions provided a neat solution to a real world problem. Well, sorry Steve, but... | |
| | | | |
curatedsql.com
|
|
| | | |||