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
Library Query
Cross Tab With Totals
1225. Report Contiguous Dates
SQL Lab
user
Return IDs where there are exactly 3 occurrences1
Many to many
Ecommerce Website Analysis by SQL
book suggestion
Persy_Jackson