Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Q4_2
--PostgreSQL 9.6 --'\\' is a delimiter CREATE TABLE spam (Name CHAR(20), Address CHAR(20), ID INTEGER, SameFam INTEGER); INSERT INTO spam(Name,Address,ID,SameFam) VALUES ('Alice','A',10,NULL), ('Bob','B',15,NULL), ('Carmen','C',22,NULL), ('Diego','A',9,10), ('Ella','B',3,15), ('Frankhad','D',11,NULL) ; SELECT *FROM spam; DELETE FROM spam WHERE name in (SELECT E1.name as name FROM spam as E1,spam as E2 WHERE E1.ID = E2.SameFam) and SameFam IS NULL; SELECT *FROM spam;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
proj
univesp
renaming JSON field
1280. Students and Examinations
fgf
arjun
Replace key of json
funkcia_transakcie
Movie Rating SQL Analysis Project
ECommerce Website SQL Analysis by Iggy Zhao
Please log in to post a comment.