Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
OUTER JOIN
CREATE TABLE myStudents ( id INT, name VARCHAR(100), age INT CHECK(age > 0) ); CREATE TABLE myCourses( id INT PRIMARY KEY, name VARCHAR(100), catagory VARCHAR(100), numberOfStudents INT CHECK ( numberOfStudents > = 0) ); CREATE TABLE enrolled( student INT, course INT, PRIMARY KEY (student, course) ) INSERT INTO enrolled VALUES (1,1), (1,2), (2,3), (2,1), (3,1), (1,4); INSERT INTO myStudents VALUES (1,'Petr', 20), (2, 'AVA', 23); INSERT INTO myCourses (name, numberOfStudents, id, catagory) VALUES ('SQL', 5000, 1, 'Development'), ('Java', 10000, 2, 'Programming'), ('C', 1000, 3, 'Programming'); SELECT s.name as student, c.name as course FROM enrolled FULL OUTER JOIN myStudents as s ON s.id = enrolled.student FULL OUTER JOIN myCourses as c ON c.id = enrolled.course;
run
|
edit
|
history
|
help
0
Creation tables
Sample of Update~Delete with OUTPUT clause (2016 >)
20181CSE0041
Datos relacional BRYAN
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers.#3
FIGURA5.4
Create Date list (variable dates) - SQL Server
Teacher
group_concat in sql-server
SQL Server : Calculate Going Step (Yutthana Thanomklay)