Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Return IDs where there are exactly 3 occurrences1
PC02-DB-UTEC
LeetCode 262
Demande complète
E-commerce Website SQL Analysis
Select the latest id from last week from each different contact without repeating barcodes.....
SQL hierarchical query. branch of responses.
Tememons Dashboard
to_char(now(), 'YYYYddd')
JieShenLaiOfferSQL
Please log in to post a comment.