Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1225. Report Contiguous Dates
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists failed; drop table if exists succeeded; Create table Failed ("fail_date" date); Create table Succeeded ("success_date" date); insert into Failed (fail_date) values ('2018-12-28'), ('2018-12-29'), ('2019-01-04'), ('2019-01-05'); insert into Succeeded (success_date) values ('2018-12-30'), ('2018-12-31'), ('2019-01-01'), ('2019-01-02'), ('2019-01-03'), ('2019-01-06');
run
|
edit
|
history
|
help
0
Distinct row aggregation with ordering - stackoverflow.com/q/43249053/4116017
Dashes in numbers
Join elements by key with json fields
POSTGRESQL_CLOSEST_VALUE
Branch
Cross Tab With Totals
Q3
cte
Laidata Practice
PC02-DB-UTEC