List Question
20 TechQA 2024-03-29T11:02:43.063000SQL: Assigning occasion numbers to GPS points when visiting places based on conditions
59 views
Asked by Beau
MySQL query to find the customers who have placed orders on consecutive days
72 views
Asked by user23860092
Query to sum over multiple rows based on column
73 views
Asked by clubkli
SQL 2019 -Group by Id and Date field
47 views
Asked by Vad
Sessionize by source and duration in PostgreSQL
22 views
Asked by kva
Rollup values between numbers > zero
50 views
Asked by user3241602
Values based on preceding rows: when x>2 then repeat 1, when x=0 for 3 consecutive rows then repeat 0
63 views
Asked by Serge Kashlik
How to get previous record by date in case of no match in a join condition
63 views
Asked by ekm0d
PostgresSql backfill data if doesn't exist for a start period
44 views
Asked by Dashing Boy
How to turn an operation and timestamp in rows into separate columns using PL SQL
53 views
Asked by prestan
How to group data where no logical grouping is available in oracle
54 views
Asked by Astitva
Group by columns when date ranges are contiguous
147 views
Asked by Vaccano
Get records that have exactly (n) records in a row continuously
99 views
Asked by DooDoo
Cross timeline count across subscriptions for customers
77 views
Asked by Loïc Chabut
Oracle rank a chronological range of records based on a condition
41 views
Asked by yankee
How to create sequence data with SQL Server?
61 views
Asked by CuteeeeRabbit
Update duplicate values to the next free number
56 views
Asked by GaripTipici
Get combined intervals for registrations and statuses
63 views
Asked by Alexey Panevin
Create dummy column that indicates when something happened between an interval
88 views
Asked by geek45
Get combined intervals for overlapping sessions
70 views
Asked by Alexey Panevin