Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Cross and outer apply
CREATE FUNCTION fn_SomeFunction ( @param int ) RETURNS TABLE AS RETURN ( select 1 as 'func_ID' union select 5 as 'func_ID' ) GO select * from pilots select * from Pilots pilots cross apply [dbo].fn_SomeFunction(pilots.id) ids select * from Pilots pilots outer apply [dbo].fn_SomeFunction(pilots.id) ids
run
|
edit
|
history
|
help
0
Preppin Data Challenge - Week 7
Test1
Usage of joins
my sql2
generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql
Tucha Alexander DB QA Test Tasks Answers
manish
tr3
Libros
prince46