Cross apply top for each row t1

?
1
2
3
4
5
6
7
8
9
10
11
SELECT  *
FROM    [20090716_cross].table1 t1
CROSS APPLY
(
SELECT  TOP (t1.row_count) *
FROM    [20090716_cross].table2
ORDER BY
id
) t2
ORDER BY
t1.id, t2.id

Source: explainextended.com

Similar codes

0 vote360 views1 answer
Into operator in sql
SQL
0 vote348 views1 answer
How to drop a trigger in postgresql
SQL
0 vote368 views1 answer
Mysql date time string format for marshmellow field schema
SQL
8 votes341 views1 answer
Database backup in mysql server recovery
SQL
0 vote372 views4 answers
Restart MySQL
SQL
-1 vote337 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote357 views1 answer
Order by oracle
SQL
1 vote354 views2 answers
Rebuild index sql server
SQL
1 vote422 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote338 views1 answer
Call function sql oracle
SQL