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

7 votes198 views2 answers
Oracle foreign key reference table
SQL
0 vote156 views1 answer
Sql server on mac m1
SQL
0 vote145 views1 answer
Sql period overlap
SQL
3 votes139 views1 answer
Mssql remove column
SQL
2 votes210 views2 answers
Set value to null sql
SQL
0 vote143 views1 answer
How to list function in psql
SQL
0 vote172 views10 answers
John the ripper mysql
SQL
18 votes111 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote158 views1 answer
Joomla execute raw sql
SQL
0 vote135 views1 answer
Order by monthly in sql
SQL