Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Select rows only with values separated by a given interval from other ...
with recursive t(x) as ( select * from unnest('{11,14,18,20,25,39,42,43,50,55,60,61,69,70,71}'::int[]) order by random()), r(x) as ( select min(x) as x from t union all (select t.x from t join r on (t.x >= r.x + 10) order by t.x limit 1)) select * from r;
run
|
edit
|
history
|
help
0
distinct on vs row_number
Tic tac toe
LeetCode 178
stackoverflow example for 47702144
hw
Pedido
Projeto
tegs and users
PosgresSQL Sandbox: Legitimate Resale
Professional Networking Social Media Website SQL Analysis