Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1075-1077 Project Analysis
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists Project; drop table if exists Employee; Create table Project("project_id" int, "employee_id" int); Create table Employee("employee_id" int, "name" varchar(255), "experience_years" int); insert into Project("project_id", "employee_id") values (1, 1), (1, 2), (1, 3), (2, 1), (2, 4); insert into Employee ("employee_id", "name", "experience_years") values (1, 'Khaled', 3), (2, 'Ali', 2), (3, 'John', 1), (4, 'Doe', 2);
run
|
edit
|
history
|
help
0
pgsql trigger 01 - Ovocie
Ass2 q2
loggin_trigger-audit
Studco
array comparison
PostgreSQL pivot using temp view
Q2
pgsql trigger 01 - Ovocie
PostreSQL: Subquery
3c