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

4 votes290 views1 answer
SQL order random
SQL
22 votes303 views4 answers
Mysql date format
SQL
1 vote309 views1 answer
List all triggers in SQL Server
SQL
0 vote299 views1 answer
Convert rows into columns in oracle
SQL
19 votes312 views5 answers
Change column name mysql command line
SQL
3 votes295 views1 answer
Oracle apex message quit website
SQL
0 vote304 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote335 views1 answer
Get clob size oracle
SQL
0 vote326 views1 answer
What is top n result in sql
SQL
2 votes342 views2 answers
Mysql on duplicate key update get value from values
SQL