Prescient Analytics

SQL

Blog tagged as SQL

Handling "Valid" SQL Join Duplication

By kpauligk

A method of removing rows resulting from valid join duplication
06/12/2019 12:45 PM - Comment(s)
Read more
Grouping Data by Attribute Using Lag & Cumulative Sum

Grouping Data by Attribute Using Lag & Cumulative Sum

By kpauligk

Simple way of use the lag function to create groups within data.
21/02/2019 03:11 PM - Comment(s)
Read more
Grouping Temporal Sequences in SQL

Grouping Temporal Sequences in SQL

By kpauligk

How to group transaction records into sequences using SQL.
08/10/2018 10:45 PM - Comment(s)
Read more
Subscribe to RSS Feed

Categories

Tags