SQL group multiple transactions into one based on time between (LAG function?)
I am working with forecourt machine data (e.g. jet wash / air) that accepts coins to operate. Each coin is a transaction line. However, I want to group up multiple rows into one ‘transaction’ if the coins went in less than 3 minutes apart.
SQL group multiple transactions into one based on time between (LAG function?)
I am working with forecourt machine data (e.g. jet wash / air) that accepts coins to operate. Each coin is a transaction line. However, I want to group up multiple rows into one ‘transaction’ if the coins went in less than 3 minutes apart.
SQL group multiple transactions into one based on time between (LAG function?)
I am working with forecourt machine data (e.g. jet wash / air) that accepts coins to operate. Each coin is a transaction line. However, I want to group up multiple rows into one ‘transaction’ if the coins went in less than 3 minutes apart.
SQL group multiple transactions into one based on time between (LAG function?)
I am working with forecourt machine data (e.g. jet wash / air) that accepts coins to operate. Each coin is a transaction line. However, I want to group up multiple rows into one ‘transaction’ if the coins went in less than 3 minutes apart.
SQL group multiple transactions into one based on time between (LAG function?)
I am working with forecourt machine data (e.g. jet wash / air) that accepts coins to operate. Each coin is a transaction line. However, I want to group up multiple rows into one ‘transaction’ if the coins went in less than 3 minutes apart.
SQL group multiple transactions into one based on time between (LAG function?)
I am working with forecourt machine data (e.g. jet wash / air) that accepts coins to operate. Each coin is a transaction line. However, I want to group up multiple rows into one ‘transaction’ if the coins went in less than 3 minutes apart.