Run Code
|
API
|
Code Wall
|
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
statistics
SQL social network practice by Han Wang 20200720 - 2
PostreSQL: Today's Date/Time
loggin_trigger-audit
Mandelbrot
m,,nm,
Movie Rating SQL Analysis Project
Many to many
Assignment 1(SET A)
SQL3