Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL left join
--Title of this code --Batches are separated by 'go' --select @@version as 'sql server version' --select * from Pilots --go select * from Flights go --select * from Planes --go --select * from Pilots_on_flights --go select Fl.[From] as 'From', Fl.[To] as 'To', Fl.Departure_date as 'Departure Date', Plane.Model as 'Plane Model', Plane.Number_of_seats as 'Seats' from Flights as Fl left join Planes as Plane on Fl.Planes_ID = Plane.ID
run
|
edit
|
history
|
help
0
Sql Server sys.syslanguages
megha
tarefaum
Turn comma-separated numbers in string into rows
Hierarchy table to exclude root
employee table
table creation
№3
lab5
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers. #5