Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
1225. Report Contiguous Dates
3
1075-1077 Project Analysis
E-commerce Website SQL Analysis
Shortest "path" between two employees across companies
Yandex Task
distinct on vs row_number
testo
Limit & union
PostreSQL: Today's Date/Time
Please log in to post a comment.