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

-1 vote338 views1 answer
Mysql #1064 error
SQL
3 votes405 views5 answers
No module named 'MySQLdb'
SQL
0 vote330 views1 answer
Denormalise SQL command
SQL
0 vote322 views1 answer
Oracle index hint multiple tables example
SQL
-1 vote338 views1 answer
Count occurrences sql
SQL
2 votes349 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
5 votes375 views1 answer
Sql integer to serial
SQL
0 vote343 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote337 views1 answer
Sqlite3 read only
SQL
1 vote327 views1 answer
Mysql collation
SQL