Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Rno 37 boat 2
create table sailors(id int, name char(10), rating int, age int); create table reserve(id int,bid int, day char(10)); create table boats(bid int, bname char(10), colour char(10)); insert into sailors(id,name,rating,age) values(1,'A', 2, 20); insert into sailors(id,name,rating,age) values(2,'B', 3, 25); insert into sailors(id,name,rating,age) values(3,'C', 5, 28); insert into reserve(id, bid, day) values(1,101,'17-12-2019'); insert into reserve(id, bid, day) values(2,104,'21-12-2019'); insert into boats(bid, bname, colour) values(101,'R','Blue'); insert into boats(bid, bname, colour) values(104,'K','Red'); select R.id from reserve R, boats B where R.bid =B.bid and B.colour='Blue' select S.name from sailors S, reserve R, boats B where S.id=R.id and R.bid=B.bid and B.colour='Blue' select b.colour from sailors S, reserve R, boats B where S.id= R.id and R.bid= B.bid and S.name='A' select S.name from sailors S, reserve R where S.id=R.id and R.bid=104
run
|
edit
|
history
|
help
0
BTVN_QLDT_TUAN 8
DBMS ca2
Veterinary 1
Get all dates between two given dates
Arif Secoond Query
Crea, inserta y confirma tabla
sql_fb
Train Reservation
Mywall
variables and table variables inside a cursor loop