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
TEST 2
Sundays in 2017
TSQL - Logic driven by two most recent rows
Cine latinoamericano
Xml Excercise 3
c12part2
Test row_number() ordering when CTE referenced multiple times
exp7
Digital Innovation One - SQL Server _2
Time Difference Calculation (amended v2)