Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Sql
create table alumno(dni int primary key not null,nombre char(15),apellido char(15)) go create table materias(cod_mat int primary key not null,nom_mat char(30),alu_dni int references alumno(dni)) go create table comision(nom_com char(2) ,alu_dni int references alumno(dni),mat_cod int references materias(cod_mat)) go insert into alumno(dni,nombre,apellido) values(1,'Nico','J') go insert into materias(cod_mat,nom_mat,alu_dni) values(1,'mate',1),(2,'lit.',1) go insert into comision(nom_com,alu_dni,mat_cod) values(1,1,1),(1,1,2) go select * from comision go
run
|
edit
|
history
|
help
0
Trabalho.Agrecação
Hierarchy table to exclude root
tarefaum
Performance test - select vs while - Get all days between two dates.
Except Insert missing
hhzn
20181CSE0068
BC160401693
ms sql where ,like
store1