Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
postgresql select test
drop table if exists form_translations; create table form_translations (id integer, translations jsonb, form_id integer); insert into form_translations values (1, '{"ru": {"tooltip": "Моя подсказка 1", "notation": "Мое обозначение 1"}, "en": {"tooltip": "My tooltip 1", "notation": "My notation 1"}}', 3), (2, '{"ru": {"tooltip": "Моя подсказка 2", "notation": "Мое обозначение 2"}, "en": {"tooltip": "My tooltip 2", "notation": "My notation 2"}}', 2), (3, '{"ru": {"tooltip": "Моя подсказка 3", "notation": "Мое обозначение 3"}, "en": {"tooltip": "My tooltip 3", "notation": "My notation 3"}}', 1); drop table if exists forms; create table forms (id integer, summary text); insert into forms values (1, 'Form 1'), (2, 'Form 2'), (3, 'Form 3'); drop table if exists users; create table users (id integer, name text, locale text); insert into users values (1, 'Archi', 'ru'), (2, 'Bob', 'en'), (3, 'Coby', 'en'); select * from form_translations; select * from forms; select * from users;
run
|
edit
|
history
|
help
0
histogram to percentiles
mandelbrot set
E-Commerce SQL Analysis by Ran Li
Full text search
stackoverflow example for 47702144
Inner Join
PostreSQL: warehouse table
MovieRating SQL
Movie Rating SQL Analysis Conducted by Miranda Zhao
Food Delivery Website SQL Analysis