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)) create table materias(cod_mat int primary key not null, nom_mat char(30), alu_dni int references alumno(dni)) create table comision(nom_com char(2) , alu_dni int references alumno(dni), mat_cod int references materias(cod_mat)) insert into alumno(dni,nombre,apellido) values(1,'Nico','J') insert into materias(cod_mat,nom_mat,alu_dni) values(1,'mate',1),(2,'lit.',1) insert into comision(nom_com,alu_dni,mat_cod) values(1,1,1),(1,1,2) select * from comision
run
|
edit
|
history
|
help
0
MixT
TSQL - Globally unique string generator
store1
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...
megha
Basic Template
SQL query to find difference in text between different rows
2021-03-09_LeetCodeSQL
Dividing runs by time stamp
SQL2