Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Assignment 1(SET A)
create table patient(p_no int primary key, address varchar(50),p_name varchar(20)); create table bed(bed_no int primary key, room_no int, description varchar (30)); ---one to one relationship create table patients(p_no int primary key, p_name varchar(20), address varchar (50), patient_bed int references bed(bed_no)); insert into patient values(1,'koregaon park','vinayak'); insert into patient values(2,'wagholi','dheeraj'); insert into bed values(11,'106','single bed'); select * from patient; select * from bed;
run
|
edit
|
history
|
help
0
SQL social network practice by Han Wang 20200720 - 2
Tememons Dashboard
Correlated subquery in SELECT clause, and rewritten for Netezza
Ass2 q2
Shortest "path" between two employees across companies
Movie Rating SQL Analysis Project
SQL Movie-Rating Query Exercises
test jsonb_set of PostgreSQL
cpana
PostgreSQL: Inner Join