Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
arjun
SQL hierarchical query. branch of responses.
find null in any column of table using PostgreSQL
Krug_test
Select all countries that can be found by recursively adding all neighbouring countries (PostgreSQL)
FinaleNFJNDFJKSN
timestamp sample
Finale8E9237394
Assignment 1(SET A)
Library Query
Please log in to post a comment.