Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
common table expression
-- CTE (common table expressions) --a way to get from representation A to representation B in multiple small steps --just a meaningless example with one_two as ( select 1 as number union select 2 as number ) , three_four as ( select 3 as number union select 4 as number ) , pilots_with_number as ( select * from pilots left outer join one_two on 1=1 ) , planes_with_numbers as ( select * from planes left outer join three_four on 1=1 ) select * from pilots_with_number left outer join planes_with_numbers on 1=1
run
|
edit
|
history
|
help
0
Teset
h
dk
Empleados
Task_7_Final
Arif First Query
BC160401693
[SQLS]-Split and update a column
SQL left join
employees