Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Veterinary 1
CREATE TABLE VETERINARY ( Pet_name char(20), Etá char(5), Tipo char(15), Razza char(20), Peso char(5), Tipo_di_servizio char(20), Tarifa char(11), Nome_cliente char(20), Id char(15), Telefono char(20) ); insert into VETERINARY (Pet_name,Etá,Tipo,Razza,Peso,Tipo_di_servizio,Tarifa,Nome_cliente,Id,Telefono) VALUES ('Tadeo','2','gatto','california_spangled','3kg','pet_spa','40$','Estefania','1225093050','3108243237'); insert into VETERINARY (Pet_name,Etá,Tipo,Razza,Peso,Tipo_di_servizio,Tarifa,Nome_cliente,Id,Telefono) VALUES ('Olafo','8','cane','beagle','5kg','ospedale','70$','Maria_del_Mar','1088346980','3234195589');
run
|
edit
|
history
|
help
0
TRY_SQL
c12part2
remove duplicated rows
Primary key and unique key for single column and multi columns
Caronas
Exam
Combined Where and having
try catch, raiserror and throw
Q2_60min
Select empID whose salary is greater than their managers