Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Descriptor test
CREATE TABLE person12 ( id integer, first_name VARCHAR(30), last_name VARCHAR(30), middle_name VARCHAR(50), descriptor VARCHAR(100) ); INSERT INTO person12 VALUES ('1', 'Ivan', 'Ivanov', 'Ivanovich', null); INSERT INTO person12 VALUES ('2', 'Ivana', 'Ivanova', null, null); INSERT INTO person12 VALUES ('3', 'Ivans', null, 'Ivanovichs', null); INSERT INTO person12 VALUES ('4', null, null, 'Ivanovichs', null); INSERT INTO person12 VALUES ('5', null, null, null, null); update person12 set descriptor = TRIM(both ' ' from concat(last_name, ' ', first_name, ' ', middle_name)); select * from person12;
run
|
edit
|
history
|
help
0
Demande complète
Count total records
test
PostreSQL: CASE
Islands demonstration
How i can get the difference of closest two date in two table join in postgresql
statistics
Movie Rating SQL Analysis Conducted by Miranda Zhao
Join elements by key with json fields
distinct on vs row_number