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 vote242 views1 answer
Limit in access query
SQL
0 vote227 views1 answer
Mysql date minus 1 day
SQL
0 vote215 views1 answer
Sql server delete records with specific date
SQL
0 vote229 views1 answer
Data structures in sql
SQL
0 vote183 views2 answers
How to combine two sql queries in one result
SQL
0 vote231 views1 answer
Mysql equivalent decode oracle
SQL
0 vote246 views1 answer
Change role postgres
SQL
0 vote229 views1 answer
Sqlalchemy query return only n results
SQL
0 vote225 views2 answers
Default constraint in ms sql
SQL
1 vote239 views1 answer
Hackerrank sql test solutions
SQL