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

0 vote234 views1 answer
Postgres in operator with comma separated values
SQL
6 votes236 views2 answers
Mysql first day of month
SQL
2 votes201 views1 answer
Mysql admin u root p password change password
SQL
3 votes263 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote253 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote221 views1 answer
Mysql group rows with same value
SQL
1 vote238 views1 answer
Sql into vs insert into
SQL
2 votes221 views1 answer
Sql select min value from multiple columns
SQL
0 vote239 views1 answer
Copy Table from SQL to CSV
SQL
4 votes220 views1 answer
Sql group by year
SQL