Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Select rows with no intersection on join table and check by date
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--PostgreSQL 9.6 --'\\' is a delimiter create table source (created_at DATE, num INT, name VARCHAR(255)); create table filter (created_at DATE, num INT); insert into source (created_at, num, name) values ('2018-01-01', 1, '11'), ('2018-01-02', 2, '22'), ('2018-01-03', 3, '33'), ('2018-01-03', 9, '99'), ('2018-01-04', 4, '44'), ('2018-01-05', 5, '55'); insert into filter (created_at, num) values ('2018-01-01', 1), ('2018-01-02', 2), ('2018-01-03', 3), ('2018-01-04', 1), ('2018-01-05', 4), ('2018-01-05', 7); select * from source; select * from filter; select * from source left join filter on filter.num = source.num where filter.num IS NULL and source.created_at >= '2018-01-01' and source.created_at <= '2018-01-05' order by source.created_at asc ;
absolute service time: 0,45 sec
fork mode
|
history
|
discussion