Sql cross apply vs join

SELECT M.ID,M.NAME,D.PERIOD,D.QTY
FROM MASTER M
INNER JOIN
(
    SELECT TOP 2 ID, PERIOD,QTY 
    FROM DETAILS D      
    ORDER BY CAST(PERIOD AS DATE)DESC
)D
ON M.ID=D.ID

Source: stackoverflow.com

Similar codes

1 vote178 views1 answer
Multiple count in sql
SQL
13 votes302 views4 answers
Sql joining 3 tables
SQL
0 vote186 views2 answers
Psql commande \gset
SQL
5 votes178 views3 answers
Select tables from mysql database
SQL
3 votes160 views1 answer
Sql set null
SQL
1 vote143 views1 answer
Restart identity postgresql
SQL
0 vote175 views1 answer
Mysql sql select one day before
SQL
16 votes210 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
25 votes189 views3 answers
How to use a database to see tables mysql
SQL
1 vote188 views2 answers
Remove space in mysql
SQL