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 vote206 views1 answer
Placements hackerrank solution
SQL
0 vote192 views1 answer
Mariadb datetime change to microseconds
SQL
10 votes196 views6 answers
Sql between
SQL
0 vote221 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote192 views1 answer
If column value is null then in mysql
SQL
0 vote222 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote190 views1 answer
Mssql check if date is greater than today
SQL
0 vote189 views1 answer
Mysqldump don't drop table
SQL
2 votes196 views1 answer
Sql to char function with date
SQL
13 votes192 views2 answers
Check if value is null mysql
SQL