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
Factorial
mi
consecutive_nums_2
SQL Interview Questions : Customer Orders
Task2
2021.02.24 Lab 4
exp7
sql
Rename column name using 'sp_rename' command
dbray